package com.hrd.mybatis.bean.auto;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TMachineExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected int limitStart = -1;

    protected int limitEnd = -1;

    public TMachineExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimitStart(int limitStart) {
        this.limitStart=limitStart;
    }

    public int getLimitStart() {
        return limitStart;
    }

    public void setLimitEnd(int limitEnd) {
        this.limitEnd=limitEnd;
    }

    public int getLimitEnd() {
        return limitEnd;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andFidIsNull() {
            addCriterion("fID is null");
            return (Criteria) this;
        }

        public Criteria andFidIsNotNull() {
            addCriterion("fID is not null");
            return (Criteria) this;
        }

        public Criteria andFidEqualTo(Integer value) {
            addCriterion("fID =", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidNotEqualTo(Integer value) {
            addCriterion("fID <>", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidGreaterThan(Integer value) {
            addCriterion("fID >", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fID >=", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidLessThan(Integer value) {
            addCriterion("fID <", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidLessThanOrEqualTo(Integer value) {
            addCriterion("fID <=", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidIn(List<Integer> values) {
            addCriterion("fID in", values, "fid");
            return (Criteria) this;
        }

        public Criteria andFidNotIn(List<Integer> values) {
            addCriterion("fID not in", values, "fid");
            return (Criteria) this;
        }

        public Criteria andFidBetween(Integer value1, Integer value2) {
            addCriterion("fID between", value1, value2, "fid");
            return (Criteria) this;
        }

        public Criteria andFidNotBetween(Integer value1, Integer value2) {
            addCriterion("fID not between", value1, value2, "fid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidIsNull() {
            addCriterion("fItemClassID is null");
            return (Criteria) this;
        }

        public Criteria andFitemclassidIsNotNull() {
            addCriterion("fItemClassID is not null");
            return (Criteria) this;
        }

        public Criteria andFitemclassidEqualTo(Integer value) {
            addCriterion("fItemClassID =", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidNotEqualTo(Integer value) {
            addCriterion("fItemClassID <>", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidGreaterThan(Integer value) {
            addCriterion("fItemClassID >", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fItemClassID >=", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidLessThan(Integer value) {
            addCriterion("fItemClassID <", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidLessThanOrEqualTo(Integer value) {
            addCriterion("fItemClassID <=", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidIn(List<Integer> values) {
            addCriterion("fItemClassID in", values, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidNotIn(List<Integer> values) {
            addCriterion("fItemClassID not in", values, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidBetween(Integer value1, Integer value2) {
            addCriterion("fItemClassID between", value1, value2, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidNotBetween(Integer value1, Integer value2) {
            addCriterion("fItemClassID not between", value1, value2, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidIsNull() {
            addCriterion("fCompanyID is null");
            return (Criteria) this;
        }

        public Criteria andFcompanyidIsNotNull() {
            addCriterion("fCompanyID is not null");
            return (Criteria) this;
        }

        public Criteria andFcompanyidEqualTo(Integer value) {
            addCriterion("fCompanyID =", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNotEqualTo(Integer value) {
            addCriterion("fCompanyID <>", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidGreaterThan(Integer value) {
            addCriterion("fCompanyID >", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fCompanyID >=", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidLessThan(Integer value) {
            addCriterion("fCompanyID <", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidLessThanOrEqualTo(Integer value) {
            addCriterion("fCompanyID <=", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidIn(List<Integer> values) {
            addCriterion("fCompanyID in", values, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNotIn(List<Integer> values) {
            addCriterion("fCompanyID not in", values, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidBetween(Integer value1, Integer value2) {
            addCriterion("fCompanyID between", value1, value2, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNotBetween(Integer value1, Integer value2) {
            addCriterion("fCompanyID not between", value1, value2, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFnoIsNull() {
            addCriterion("fNO is null");
            return (Criteria) this;
        }

        public Criteria andFnoIsNotNull() {
            addCriterion("fNO is not null");
            return (Criteria) this;
        }

        public Criteria andFnoEqualTo(String value) {
            addCriterion("fNO =", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotEqualTo(String value) {
            addCriterion("fNO <>", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoGreaterThan(String value) {
            addCriterion("fNO >", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoGreaterThanOrEqualTo(String value) {
            addCriterion("fNO >=", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoLessThan(String value) {
            addCriterion("fNO <", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoLessThanOrEqualTo(String value) {
            addCriterion("fNO <=", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoLike(String value) {
            addCriterion("fNO like", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotLike(String value) {
            addCriterion("fNO not like", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoIn(List<String> values) {
            addCriterion("fNO in", values, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotIn(List<String> values) {
            addCriterion("fNO not in", values, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoBetween(String value1, String value2) {
            addCriterion("fNO between", value1, value2, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotBetween(String value1, String value2) {
            addCriterion("fNO not between", value1, value2, "fno");
            return (Criteria) this;
        }

        public Criteria andFnameIsNull() {
            addCriterion("fName is null");
            return (Criteria) this;
        }

        public Criteria andFnameIsNotNull() {
            addCriterion("fName is not null");
            return (Criteria) this;
        }

        public Criteria andFnameEqualTo(String value) {
            addCriterion("fName =", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameNotEqualTo(String value) {
            addCriterion("fName <>", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameGreaterThan(String value) {
            addCriterion("fName >", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameGreaterThanOrEqualTo(String value) {
            addCriterion("fName >=", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameLessThan(String value) {
            addCriterion("fName <", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameLessThanOrEqualTo(String value) {
            addCriterion("fName <=", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameLike(String value) {
            addCriterion("fName like", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameNotLike(String value) {
            addCriterion("fName not like", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameIn(List<String> values) {
            addCriterion("fName in", values, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameNotIn(List<String> values) {
            addCriterion("fName not in", values, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameBetween(String value1, String value2) {
            addCriterion("fName between", value1, value2, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameNotBetween(String value1, String value2) {
            addCriterion("fName not between", value1, value2, "fname");
            return (Criteria) this;
        }

        public Criteria andFvinIsNull() {
            addCriterion("fVIN is null");
            return (Criteria) this;
        }

        public Criteria andFvinIsNotNull() {
            addCriterion("fVIN is not null");
            return (Criteria) this;
        }

        public Criteria andFvinEqualTo(String value) {
            addCriterion("fVIN =", value, "fvin");
            return (Criteria) this;
        }

        public Criteria andFvinNotEqualTo(String value) {
            addCriterion("fVIN <>", value, "fvin");
            return (Criteria) this;
        }

        public Criteria andFvinGreaterThan(String value) {
            addCriterion("fVIN >", value, "fvin");
            return (Criteria) this;
        }

        public Criteria andFvinGreaterThanOrEqualTo(String value) {
            addCriterion("fVIN >=", value, "fvin");
            return (Criteria) this;
        }

        public Criteria andFvinLessThan(String value) {
            addCriterion("fVIN <", value, "fvin");
            return (Criteria) this;
        }

        public Criteria andFvinLessThanOrEqualTo(String value) {
            addCriterion("fVIN <=", value, "fvin");
            return (Criteria) this;
        }

        public Criteria andFvinLike(String value) {
            addCriterion("fVIN like", value, "fvin");
            return (Criteria) this;
        }

        public Criteria andFvinNotLike(String value) {
            addCriterion("fVIN not like", value, "fvin");
            return (Criteria) this;
        }

        public Criteria andFvinIn(List<String> values) {
            addCriterion("fVIN in", values, "fvin");
            return (Criteria) this;
        }

        public Criteria andFvinNotIn(List<String> values) {
            addCriterion("fVIN not in", values, "fvin");
            return (Criteria) this;
        }

        public Criteria andFvinBetween(String value1, String value2) {
            addCriterion("fVIN between", value1, value2, "fvin");
            return (Criteria) this;
        }

        public Criteria andFvinNotBetween(String value1, String value2) {
            addCriterion("fVIN not between", value1, value2, "fvin");
            return (Criteria) this;
        }

        public Criteria andFtypeidIsNull() {
            addCriterion("fTypeID is null");
            return (Criteria) this;
        }

        public Criteria andFtypeidIsNotNull() {
            addCriterion("fTypeID is not null");
            return (Criteria) this;
        }

        public Criteria andFtypeidEqualTo(Integer value) {
            addCriterion("fTypeID =", value, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidNotEqualTo(Integer value) {
            addCriterion("fTypeID <>", value, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidGreaterThan(Integer value) {
            addCriterion("fTypeID >", value, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fTypeID >=", value, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidLessThan(Integer value) {
            addCriterion("fTypeID <", value, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidLessThanOrEqualTo(Integer value) {
            addCriterion("fTypeID <=", value, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidIn(List<Integer> values) {
            addCriterion("fTypeID in", values, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidNotIn(List<Integer> values) {
            addCriterion("fTypeID not in", values, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidBetween(Integer value1, Integer value2) {
            addCriterion("fTypeID between", value1, value2, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidNotBetween(Integer value1, Integer value2) {
            addCriterion("fTypeID not between", value1, value2, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFcoloridIsNull() {
            addCriterion("fColorID is null");
            return (Criteria) this;
        }

        public Criteria andFcoloridIsNotNull() {
            addCriterion("fColorID is not null");
            return (Criteria) this;
        }

        public Criteria andFcoloridEqualTo(Integer value) {
            addCriterion("fColorID =", value, "fcolorid");
            return (Criteria) this;
        }

        public Criteria andFcoloridNotEqualTo(Integer value) {
            addCriterion("fColorID <>", value, "fcolorid");
            return (Criteria) this;
        }

        public Criteria andFcoloridGreaterThan(Integer value) {
            addCriterion("fColorID >", value, "fcolorid");
            return (Criteria) this;
        }

        public Criteria andFcoloridGreaterThanOrEqualTo(Integer value) {
            addCriterion("fColorID >=", value, "fcolorid");
            return (Criteria) this;
        }

        public Criteria andFcoloridLessThan(Integer value) {
            addCriterion("fColorID <", value, "fcolorid");
            return (Criteria) this;
        }

        public Criteria andFcoloridLessThanOrEqualTo(Integer value) {
            addCriterion("fColorID <=", value, "fcolorid");
            return (Criteria) this;
        }

        public Criteria andFcoloridIn(List<Integer> values) {
            addCriterion("fColorID in", values, "fcolorid");
            return (Criteria) this;
        }

        public Criteria andFcoloridNotIn(List<Integer> values) {
            addCriterion("fColorID not in", values, "fcolorid");
            return (Criteria) this;
        }

        public Criteria andFcoloridBetween(Integer value1, Integer value2) {
            addCriterion("fColorID between", value1, value2, "fcolorid");
            return (Criteria) this;
        }

        public Criteria andFcoloridNotBetween(Integer value1, Integer value2) {
            addCriterion("fColorID not between", value1, value2, "fcolorid");
            return (Criteria) this;
        }

        public Criteria andFpidIsNull() {
            addCriterion("fPID is null");
            return (Criteria) this;
        }

        public Criteria andFpidIsNotNull() {
            addCriterion("fPID is not null");
            return (Criteria) this;
        }

        public Criteria andFpidEqualTo(Integer value) {
            addCriterion("fPID =", value, "fpid");
            return (Criteria) this;
        }

        public Criteria andFpidNotEqualTo(Integer value) {
            addCriterion("fPID <>", value, "fpid");
            return (Criteria) this;
        }

        public Criteria andFpidGreaterThan(Integer value) {
            addCriterion("fPID >", value, "fpid");
            return (Criteria) this;
        }

        public Criteria andFpidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fPID >=", value, "fpid");
            return (Criteria) this;
        }

        public Criteria andFpidLessThan(Integer value) {
            addCriterion("fPID <", value, "fpid");
            return (Criteria) this;
        }

        public Criteria andFpidLessThanOrEqualTo(Integer value) {
            addCriterion("fPID <=", value, "fpid");
            return (Criteria) this;
        }

        public Criteria andFpidIn(List<Integer> values) {
            addCriterion("fPID in", values, "fpid");
            return (Criteria) this;
        }

        public Criteria andFpidNotIn(List<Integer> values) {
            addCriterion("fPID not in", values, "fpid");
            return (Criteria) this;
        }

        public Criteria andFpidBetween(Integer value1, Integer value2) {
            addCriterion("fPID between", value1, value2, "fpid");
            return (Criteria) this;
        }

        public Criteria andFpidNotBetween(Integer value1, Integer value2) {
            addCriterion("fPID not between", value1, value2, "fpid");
            return (Criteria) this;
        }

        public Criteria andFlevelIsNull() {
            addCriterion("fLevel is null");
            return (Criteria) this;
        }

        public Criteria andFlevelIsNotNull() {
            addCriterion("fLevel is not null");
            return (Criteria) this;
        }

        private Criteria andFlevelEqualTo_back(Byte value) {
            addCriterion("fLevel =", value, "flevel");
            return (Criteria) this;
        }

        private Criteria andFlevelNotEqualTo_back(Byte value) {
            addCriterion("fLevel <>", value, "flevel");
            return (Criteria) this;
        }

        private Criteria andFlevelGreaterThan_back(Byte value) {
            addCriterion("fLevel >", value, "flevel");
            return (Criteria) this;
        }

        private Criteria andFlevelGreaterThanOrEqualTo_back(Byte value) {
            addCriterion("fLevel >=", value, "flevel");
            return (Criteria) this;
        }

        private Criteria andFlevelLessThan_back(Byte value) {
            addCriterion("fLevel <", value, "flevel");
            return (Criteria) this;
        }

        private Criteria andFlevelLessThanOrEqualTo_back(Byte value) {
            addCriterion("fLevel <=", value, "flevel");
            return (Criteria) this;
        }

        public Criteria andFlevelIn(List<Byte> values) {
            addCriterion("fLevel in", values, "flevel");
            return (Criteria) this;
        }

        public Criteria andFlevelNotIn(List<Byte> values) {
            addCriterion("fLevel not in", values, "flevel");
            return (Criteria) this;
        }

        private Criteria andFlevelBetween_back(Byte value1, Byte value2) {
            addCriterion("fLevel between", value1, value2, "flevel");
            return (Criteria) this;
        }

        private Criteria andFlevelNotBetween_back(Byte value1, Byte value2) {
            addCriterion("fLevel not between", value1, value2, "flevel");
            return (Criteria) this;
        }

        public Criteria andFdetailIsNull() {
            addCriterion("fDetail is null");
            return (Criteria) this;
        }

        public Criteria andFdetailIsNotNull() {
            addCriterion("fDetail is not null");
            return (Criteria) this;
        }

        private Criteria andFdetailEqualTo_back(Boolean value) {
            addCriterion("fDetail =", value, "fdetail");
            return (Criteria) this;
        }

        private Criteria andFdetailNotEqualTo_back(Boolean value) {
            addCriterion("fDetail <>", value, "fdetail");
            return (Criteria) this;
        }

        private Criteria andFdetailGreaterThan_back(Boolean value) {
            addCriterion("fDetail >", value, "fdetail");
            return (Criteria) this;
        }

        private Criteria andFdetailGreaterThanOrEqualTo_back(Boolean value) {
            addCriterion("fDetail >=", value, "fdetail");
            return (Criteria) this;
        }

        private Criteria andFdetailLessThan_back(Boolean value) {
            addCriterion("fDetail <", value, "fdetail");
            return (Criteria) this;
        }

        private Criteria andFdetailLessThanOrEqualTo_back(Boolean value) {
            addCriterion("fDetail <=", value, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFdetailIn(List<Boolean> values) {
            addCriterion("fDetail in", values, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFdetailNotIn(List<Boolean> values) {
            addCriterion("fDetail not in", values, "fdetail");
            return (Criteria) this;
        }

        private Criteria andFdetailBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fDetail between", value1, value2, "fdetail");
            return (Criteria) this;
        }

        private Criteria andFdetailNotBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fDetail not between", value1, value2, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFenginenoIsNull() {
            addCriterion("fEngineNO is null");
            return (Criteria) this;
        }

        public Criteria andFenginenoIsNotNull() {
            addCriterion("fEngineNO is not null");
            return (Criteria) this;
        }

        public Criteria andFenginenoEqualTo(String value) {
            addCriterion("fEngineNO =", value, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoNotEqualTo(String value) {
            addCriterion("fEngineNO <>", value, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoGreaterThan(String value) {
            addCriterion("fEngineNO >", value, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoGreaterThanOrEqualTo(String value) {
            addCriterion("fEngineNO >=", value, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoLessThan(String value) {
            addCriterion("fEngineNO <", value, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoLessThanOrEqualTo(String value) {
            addCriterion("fEngineNO <=", value, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoLike(String value) {
            addCriterion("fEngineNO like", value, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoNotLike(String value) {
            addCriterion("fEngineNO not like", value, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoIn(List<String> values) {
            addCriterion("fEngineNO in", values, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoNotIn(List<String> values) {
            addCriterion("fEngineNO not in", values, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoBetween(String value1, String value2) {
            addCriterion("fEngineNO between", value1, value2, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoNotBetween(String value1, String value2) {
            addCriterion("fEngineNO not between", value1, value2, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFproductdateIsNull() {
            addCriterion("fProductDate is null");
            return (Criteria) this;
        }

        public Criteria andFproductdateIsNotNull() {
            addCriterion("fProductDate is not null");
            return (Criteria) this;
        }

        public Criteria andFproductdateEqualTo(Date value) {
            addCriterion("fProductDate =", value, "fproductdate");
            return (Criteria) this;
        }

        public Criteria andFproductdateNotEqualTo(Date value) {
            addCriterion("fProductDate <>", value, "fproductdate");
            return (Criteria) this;
        }

        public Criteria andFproductdateGreaterThan(Date value) {
            addCriterion("fProductDate >", value, "fproductdate");
            return (Criteria) this;
        }

        public Criteria andFproductdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fProductDate >=", value, "fproductdate");
            return (Criteria) this;
        }

        public Criteria andFproductdateLessThan(Date value) {
            addCriterion("fProductDate <", value, "fproductdate");
            return (Criteria) this;
        }

        public Criteria andFproductdateLessThanOrEqualTo(Date value) {
            addCriterion("fProductDate <=", value, "fproductdate");
            return (Criteria) this;
        }

        public Criteria andFproductdateIn(List<Date> values) {
            addCriterion("fProductDate in", values, "fproductdate");
            return (Criteria) this;
        }

        public Criteria andFproductdateNotIn(List<Date> values) {
            addCriterion("fProductDate not in", values, "fproductdate");
            return (Criteria) this;
        }

        public Criteria andFproductdateBetween(Date value1, Date value2) {
            addCriterion("fProductDate between", value1, value2, "fproductdate");
            return (Criteria) this;
        }

        public Criteria andFproductdateNotBetween(Date value1, Date value2) {
            addCriterion("fProductDate not between", value1, value2, "fproductdate");
            return (Criteria) this;
        }

        public Criteria andFstatusIsNull() {
            addCriterion("fStatus is null");
            return (Criteria) this;
        }

        public Criteria andFstatusIsNotNull() {
            addCriterion("fStatus is not null");
            return (Criteria) this;
        }

        public Criteria andFstatusEqualTo(Integer value) {
            addCriterion("fStatus =", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusNotEqualTo(Integer value) {
            addCriterion("fStatus <>", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusGreaterThan(Integer value) {
            addCriterion("fStatus >", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStatus >=", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusLessThan(Integer value) {
            addCriterion("fStatus <", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusLessThanOrEqualTo(Integer value) {
            addCriterion("fStatus <=", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusIn(List<Integer> values) {
            addCriterion("fStatus in", values, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusNotIn(List<Integer> values) {
            addCriterion("fStatus not in", values, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusBetween(Integer value1, Integer value2) {
            addCriterion("fStatus between", value1, value2, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusNotBetween(Integer value1, Integer value2) {
            addCriterion("fStatus not between", value1, value2, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidIsNull() {
            addCriterion("fRunStatusID is null");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidIsNotNull() {
            addCriterion("fRunStatusID is not null");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidEqualTo(Integer value) {
            addCriterion("fRunStatusID =", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidNotEqualTo(Integer value) {
            addCriterion("fRunStatusID <>", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidGreaterThan(Integer value) {
            addCriterion("fRunStatusID >", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fRunStatusID >=", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidLessThan(Integer value) {
            addCriterion("fRunStatusID <", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidLessThanOrEqualTo(Integer value) {
            addCriterion("fRunStatusID <=", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidIn(List<Integer> values) {
            addCriterion("fRunStatusID in", values, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidNotIn(List<Integer> values) {
            addCriterion("fRunStatusID not in", values, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidBetween(Integer value1, Integer value2) {
            addCriterion("fRunStatusID between", value1, value2, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidNotBetween(Integer value1, Integer value2) {
            addCriterion("fRunStatusID not between", value1, value2, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidIsNull() {
            addCriterion("fStatusID is null");
            return (Criteria) this;
        }

        public Criteria andFstatusidIsNotNull() {
            addCriterion("fStatusID is not null");
            return (Criteria) this;
        }

        public Criteria andFstatusidEqualTo(Integer value) {
            addCriterion("fStatusID =", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidNotEqualTo(Integer value) {
            addCriterion("fStatusID <>", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidGreaterThan(Integer value) {
            addCriterion("fStatusID >", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStatusID >=", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidLessThan(Integer value) {
            addCriterion("fStatusID <", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidLessThanOrEqualTo(Integer value) {
            addCriterion("fStatusID <=", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidIn(List<Integer> values) {
            addCriterion("fStatusID in", values, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidNotIn(List<Integer> values) {
            addCriterion("fStatusID not in", values, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidBetween(Integer value1, Integer value2) {
            addCriterion("fStatusID between", value1, value2, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidNotBetween(Integer value1, Integer value2) {
            addCriterion("fStatusID not between", value1, value2, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridIsNull() {
            addCriterion("fOperUserID is null");
            return (Criteria) this;
        }

        public Criteria andFoperuseridIsNotNull() {
            addCriterion("fOperUserID is not null");
            return (Criteria) this;
        }

        public Criteria andFoperuseridEqualTo(Integer value) {
            addCriterion("fOperUserID =", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridNotEqualTo(Integer value) {
            addCriterion("fOperUserID <>", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridGreaterThan(Integer value) {
            addCriterion("fOperUserID >", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridGreaterThanOrEqualTo(Integer value) {
            addCriterion("fOperUserID >=", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridLessThan(Integer value) {
            addCriterion("fOperUserID <", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridLessThanOrEqualTo(Integer value) {
            addCriterion("fOperUserID <=", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridIn(List<Integer> values) {
            addCriterion("fOperUserID in", values, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridNotIn(List<Integer> values) {
            addCriterion("fOperUserID not in", values, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridBetween(Integer value1, Integer value2) {
            addCriterion("fOperUserID between", value1, value2, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridNotBetween(Integer value1, Integer value2) {
            addCriterion("fOperUserID not between", value1, value2, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperdateIsNull() {
            addCriterion("fOperDate is null");
            return (Criteria) this;
        }

        public Criteria andFoperdateIsNotNull() {
            addCriterion("fOperDate is not null");
            return (Criteria) this;
        }

        public Criteria andFoperdateEqualTo(Date value) {
            addCriterion("fOperDate =", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateNotEqualTo(Date value) {
            addCriterion("fOperDate <>", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateGreaterThan(Date value) {
            addCriterion("fOperDate >", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fOperDate >=", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateLessThan(Date value) {
            addCriterion("fOperDate <", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateLessThanOrEqualTo(Date value) {
            addCriterion("fOperDate <=", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateIn(List<Date> values) {
            addCriterion("fOperDate in", values, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateNotIn(List<Date> values) {
            addCriterion("fOperDate not in", values, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateBetween(Date value1, Date value2) {
            addCriterion("fOperDate between", value1, value2, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateNotBetween(Date value1, Date value2) {
            addCriterion("fOperDate not between", value1, value2, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFmemoIsNull() {
            addCriterion("fMemo is null");
            return (Criteria) this;
        }

        public Criteria andFmemoIsNotNull() {
            addCriterion("fMemo is not null");
            return (Criteria) this;
        }

        public Criteria andFmemoEqualTo(String value) {
            addCriterion("fMemo =", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoNotEqualTo(String value) {
            addCriterion("fMemo <>", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoGreaterThan(String value) {
            addCriterion("fMemo >", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoGreaterThanOrEqualTo(String value) {
            addCriterion("fMemo >=", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoLessThan(String value) {
            addCriterion("fMemo <", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoLessThanOrEqualTo(String value) {
            addCriterion("fMemo <=", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoLike(String value) {
            addCriterion("fMemo like", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoNotLike(String value) {
            addCriterion("fMemo not like", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoIn(List<String> values) {
            addCriterion("fMemo in", values, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoNotIn(List<String> values) {
            addCriterion("fMemo not in", values, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoBetween(String value1, String value2) {
            addCriterion("fMemo between", value1, value2, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoNotBetween(String value1, String value2) {
            addCriterion("fMemo not between", value1, value2, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFrelationidIsNull() {
            addCriterion("fRelationID is null");
            return (Criteria) this;
        }

        public Criteria andFrelationidIsNotNull() {
            addCriterion("fRelationID is not null");
            return (Criteria) this;
        }

        public Criteria andFrelationidEqualTo(Integer value) {
            addCriterion("fRelationID =", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidNotEqualTo(Integer value) {
            addCriterion("fRelationID <>", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidGreaterThan(Integer value) {
            addCriterion("fRelationID >", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fRelationID >=", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidLessThan(Integer value) {
            addCriterion("fRelationID <", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidLessThanOrEqualTo(Integer value) {
            addCriterion("fRelationID <=", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidIn(List<Integer> values) {
            addCriterion("fRelationID in", values, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidNotIn(List<Integer> values) {
            addCriterion("fRelationID not in", values, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidBetween(Integer value1, Integer value2) {
            addCriterion("fRelationID between", value1, value2, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidNotBetween(Integer value1, Integer value2) {
            addCriterion("fRelationID not between", value1, value2, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidIsNull() {
            addCriterion("fRelationClassID is null");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidIsNotNull() {
            addCriterion("fRelationClassID is not null");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidEqualTo(Integer value) {
            addCriterion("fRelationClassID =", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidNotEqualTo(Integer value) {
            addCriterion("fRelationClassID <>", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidGreaterThan(Integer value) {
            addCriterion("fRelationClassID >", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fRelationClassID >=", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidLessThan(Integer value) {
            addCriterion("fRelationClassID <", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidLessThanOrEqualTo(Integer value) {
            addCriterion("fRelationClassID <=", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidIn(List<Integer> values) {
            addCriterion("fRelationClassID in", values, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidNotIn(List<Integer> values) {
            addCriterion("fRelationClassID not in", values, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidBetween(Integer value1, Integer value2) {
            addCriterion("fRelationClassID between", value1, value2, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidNotBetween(Integer value1, Integer value2) {
            addCriterion("fRelationClassID not between", value1, value2, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFmakestatusidIsNull() {
            addCriterion("fMakeStatusID is null");
            return (Criteria) this;
        }

        public Criteria andFmakestatusidIsNotNull() {
            addCriterion("fMakeStatusID is not null");
            return (Criteria) this;
        }

        public Criteria andFmakestatusidEqualTo(Integer value) {
            addCriterion("fMakeStatusID =", value, "fmakestatusid");
            return (Criteria) this;
        }

        public Criteria andFmakestatusidNotEqualTo(Integer value) {
            addCriterion("fMakeStatusID <>", value, "fmakestatusid");
            return (Criteria) this;
        }

        public Criteria andFmakestatusidGreaterThan(Integer value) {
            addCriterion("fMakeStatusID >", value, "fmakestatusid");
            return (Criteria) this;
        }

        public Criteria andFmakestatusidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fMakeStatusID >=", value, "fmakestatusid");
            return (Criteria) this;
        }

        public Criteria andFmakestatusidLessThan(Integer value) {
            addCriterion("fMakeStatusID <", value, "fmakestatusid");
            return (Criteria) this;
        }

        public Criteria andFmakestatusidLessThanOrEqualTo(Integer value) {
            addCriterion("fMakeStatusID <=", value, "fmakestatusid");
            return (Criteria) this;
        }

        public Criteria andFmakestatusidIn(List<Integer> values) {
            addCriterion("fMakeStatusID in", values, "fmakestatusid");
            return (Criteria) this;
        }

        public Criteria andFmakestatusidNotIn(List<Integer> values) {
            addCriterion("fMakeStatusID not in", values, "fmakestatusid");
            return (Criteria) this;
        }

        public Criteria andFmakestatusidBetween(Integer value1, Integer value2) {
            addCriterion("fMakeStatusID between", value1, value2, "fmakestatusid");
            return (Criteria) this;
        }

        public Criteria andFmakestatusidNotBetween(Integer value1, Integer value2) {
            addCriterion("fMakeStatusID not between", value1, value2, "fmakestatusid");
            return (Criteria) this;
        }

        public Criteria andFplandateIsNull() {
            addCriterion("fPlanDate is null");
            return (Criteria) this;
        }

        public Criteria andFplandateIsNotNull() {
            addCriterion("fPlanDate is not null");
            return (Criteria) this;
        }

        public Criteria andFplandateEqualTo(Date value) {
            addCriterion("fPlanDate =", value, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateNotEqualTo(Date value) {
            addCriterion("fPlanDate <>", value, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateGreaterThan(Date value) {
            addCriterion("fPlanDate >", value, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateGreaterThanOrEqualTo(Date value) {
            addCriterion("fPlanDate >=", value, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateLessThan(Date value) {
            addCriterion("fPlanDate <", value, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateLessThanOrEqualTo(Date value) {
            addCriterion("fPlanDate <=", value, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateIn(List<Date> values) {
            addCriterion("fPlanDate in", values, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateNotIn(List<Date> values) {
            addCriterion("fPlanDate not in", values, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateBetween(Date value1, Date value2) {
            addCriterion("fPlanDate between", value1, value2, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateNotBetween(Date value1, Date value2) {
            addCriterion("fPlanDate not between", value1, value2, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFconfigidIsNull() {
            addCriterion("fConfigID is null");
            return (Criteria) this;
        }

        public Criteria andFconfigidIsNotNull() {
            addCriterion("fConfigID is not null");
            return (Criteria) this;
        }

        public Criteria andFconfigidEqualTo(Integer value) {
            addCriterion("fConfigID =", value, "fconfigid");
            return (Criteria) this;
        }

        public Criteria andFconfigidNotEqualTo(Integer value) {
            addCriterion("fConfigID <>", value, "fconfigid");
            return (Criteria) this;
        }

        public Criteria andFconfigidGreaterThan(Integer value) {
            addCriterion("fConfigID >", value, "fconfigid");
            return (Criteria) this;
        }

        public Criteria andFconfigidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fConfigID >=", value, "fconfigid");
            return (Criteria) this;
        }

        public Criteria andFconfigidLessThan(Integer value) {
            addCriterion("fConfigID <", value, "fconfigid");
            return (Criteria) this;
        }

        public Criteria andFconfigidLessThanOrEqualTo(Integer value) {
            addCriterion("fConfigID <=", value, "fconfigid");
            return (Criteria) this;
        }

        public Criteria andFconfigidIn(List<Integer> values) {
            addCriterion("fConfigID in", values, "fconfigid");
            return (Criteria) this;
        }

        public Criteria andFconfigidNotIn(List<Integer> values) {
            addCriterion("fConfigID not in", values, "fconfigid");
            return (Criteria) this;
        }

        public Criteria andFconfigidBetween(Integer value1, Integer value2) {
            addCriterion("fConfigID between", value1, value2, "fconfigid");
            return (Criteria) this;
        }

        public Criteria andFconfigidNotBetween(Integer value1, Integer value2) {
            addCriterion("fConfigID not between", value1, value2, "fconfigid");
            return (Criteria) this;
        }

        public Criteria andFmkindidIsNull() {
            addCriterion("fMKindID is null");
            return (Criteria) this;
        }

        public Criteria andFmkindidIsNotNull() {
            addCriterion("fMKindID is not null");
            return (Criteria) this;
        }

        public Criteria andFmkindidEqualTo(Integer value) {
            addCriterion("fMKindID =", value, "fmkindid");
            return (Criteria) this;
        }

        public Criteria andFmkindidNotEqualTo(Integer value) {
            addCriterion("fMKindID <>", value, "fmkindid");
            return (Criteria) this;
        }

        public Criteria andFmkindidGreaterThan(Integer value) {
            addCriterion("fMKindID >", value, "fmkindid");
            return (Criteria) this;
        }

        public Criteria andFmkindidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fMKindID >=", value, "fmkindid");
            return (Criteria) this;
        }

        public Criteria andFmkindidLessThan(Integer value) {
            addCriterion("fMKindID <", value, "fmkindid");
            return (Criteria) this;
        }

        public Criteria andFmkindidLessThanOrEqualTo(Integer value) {
            addCriterion("fMKindID <=", value, "fmkindid");
            return (Criteria) this;
        }

        public Criteria andFmkindidIn(List<Integer> values) {
            addCriterion("fMKindID in", values, "fmkindid");
            return (Criteria) this;
        }

        public Criteria andFmkindidNotIn(List<Integer> values) {
            addCriterion("fMKindID not in", values, "fmkindid");
            return (Criteria) this;
        }

        public Criteria andFmkindidBetween(Integer value1, Integer value2) {
            addCriterion("fMKindID between", value1, value2, "fmkindid");
            return (Criteria) this;
        }

        public Criteria andFmkindidNotBetween(Integer value1, Integer value2) {
            addCriterion("fMKindID not between", value1, value2, "fmkindid");
            return (Criteria) this;
        }

        public Criteria andForderidIsNull() {
            addCriterion("fOrderID is null");
            return (Criteria) this;
        }

        public Criteria andForderidIsNotNull() {
            addCriterion("fOrderID is not null");
            return (Criteria) this;
        }

        public Criteria andForderidEqualTo(Integer value) {
            addCriterion("fOrderID =", value, "forderid");
            return (Criteria) this;
        }

        public Criteria andForderidNotEqualTo(Integer value) {
            addCriterion("fOrderID <>", value, "forderid");
            return (Criteria) this;
        }

        public Criteria andForderidGreaterThan(Integer value) {
            addCriterion("fOrderID >", value, "forderid");
            return (Criteria) this;
        }

        public Criteria andForderidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fOrderID >=", value, "forderid");
            return (Criteria) this;
        }

        public Criteria andForderidLessThan(Integer value) {
            addCriterion("fOrderID <", value, "forderid");
            return (Criteria) this;
        }

        public Criteria andForderidLessThanOrEqualTo(Integer value) {
            addCriterion("fOrderID <=", value, "forderid");
            return (Criteria) this;
        }

        public Criteria andForderidIn(List<Integer> values) {
            addCriterion("fOrderID in", values, "forderid");
            return (Criteria) this;
        }

        public Criteria andForderidNotIn(List<Integer> values) {
            addCriterion("fOrderID not in", values, "forderid");
            return (Criteria) this;
        }

        public Criteria andForderidBetween(Integer value1, Integer value2) {
            addCriterion("fOrderID between", value1, value2, "forderid");
            return (Criteria) this;
        }

        public Criteria andForderidNotBetween(Integer value1, Integer value2) {
            addCriterion("fOrderID not between", value1, value2, "forderid");
            return (Criteria) this;
        }

        public Criteria andFmakekindidIsNull() {
            addCriterion("fMakeKindID is null");
            return (Criteria) this;
        }

        public Criteria andFmakekindidIsNotNull() {
            addCriterion("fMakeKindID is not null");
            return (Criteria) this;
        }

        public Criteria andFmakekindidEqualTo(Integer value) {
            addCriterion("fMakeKindID =", value, "fmakekindid");
            return (Criteria) this;
        }

        public Criteria andFmakekindidNotEqualTo(Integer value) {
            addCriterion("fMakeKindID <>", value, "fmakekindid");
            return (Criteria) this;
        }

        public Criteria andFmakekindidGreaterThan(Integer value) {
            addCriterion("fMakeKindID >", value, "fmakekindid");
            return (Criteria) this;
        }

        public Criteria andFmakekindidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fMakeKindID >=", value, "fmakekindid");
            return (Criteria) this;
        }

        public Criteria andFmakekindidLessThan(Integer value) {
            addCriterion("fMakeKindID <", value, "fmakekindid");
            return (Criteria) this;
        }

        public Criteria andFmakekindidLessThanOrEqualTo(Integer value) {
            addCriterion("fMakeKindID <=", value, "fmakekindid");
            return (Criteria) this;
        }

        public Criteria andFmakekindidIn(List<Integer> values) {
            addCriterion("fMakeKindID in", values, "fmakekindid");
            return (Criteria) this;
        }

        public Criteria andFmakekindidNotIn(List<Integer> values) {
            addCriterion("fMakeKindID not in", values, "fmakekindid");
            return (Criteria) this;
        }

        public Criteria andFmakekindidBetween(Integer value1, Integer value2) {
            addCriterion("fMakeKindID between", value1, value2, "fmakekindid");
            return (Criteria) this;
        }

        public Criteria andFmakekindidNotBetween(Integer value1, Integer value2) {
            addCriterion("fMakeKindID not between", value1, value2, "fmakekindid");
            return (Criteria) this;
        }

        public Criteria andFmaintypeidIsNull() {
            addCriterion("fMainTypeID is null");
            return (Criteria) this;
        }

        public Criteria andFmaintypeidIsNotNull() {
            addCriterion("fMainTypeID is not null");
            return (Criteria) this;
        }

        public Criteria andFmaintypeidEqualTo(Integer value) {
            addCriterion("fMainTypeID =", value, "fmaintypeid");
            return (Criteria) this;
        }

        public Criteria andFmaintypeidNotEqualTo(Integer value) {
            addCriterion("fMainTypeID <>", value, "fmaintypeid");
            return (Criteria) this;
        }

        public Criteria andFmaintypeidGreaterThan(Integer value) {
            addCriterion("fMainTypeID >", value, "fmaintypeid");
            return (Criteria) this;
        }

        public Criteria andFmaintypeidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fMainTypeID >=", value, "fmaintypeid");
            return (Criteria) this;
        }

        public Criteria andFmaintypeidLessThan(Integer value) {
            addCriterion("fMainTypeID <", value, "fmaintypeid");
            return (Criteria) this;
        }

        public Criteria andFmaintypeidLessThanOrEqualTo(Integer value) {
            addCriterion("fMainTypeID <=", value, "fmaintypeid");
            return (Criteria) this;
        }

        public Criteria andFmaintypeidIn(List<Integer> values) {
            addCriterion("fMainTypeID in", values, "fmaintypeid");
            return (Criteria) this;
        }

        public Criteria andFmaintypeidNotIn(List<Integer> values) {
            addCriterion("fMainTypeID not in", values, "fmaintypeid");
            return (Criteria) this;
        }

        public Criteria andFmaintypeidBetween(Integer value1, Integer value2) {
            addCriterion("fMainTypeID between", value1, value2, "fmaintypeid");
            return (Criteria) this;
        }

        public Criteria andFmaintypeidNotBetween(Integer value1, Integer value2) {
            addCriterion("fMainTypeID not between", value1, value2, "fmaintypeid");
            return (Criteria) this;
        }

        public Criteria andFengineIsNull() {
            addCriterion("fEngine is null");
            return (Criteria) this;
        }

        public Criteria andFengineIsNotNull() {
            addCriterion("fEngine is not null");
            return (Criteria) this;
        }

        public Criteria andFengineEqualTo(String value) {
            addCriterion("fEngine =", value, "fengine");
            return (Criteria) this;
        }

        public Criteria andFengineNotEqualTo(String value) {
            addCriterion("fEngine <>", value, "fengine");
            return (Criteria) this;
        }

        public Criteria andFengineGreaterThan(String value) {
            addCriterion("fEngine >", value, "fengine");
            return (Criteria) this;
        }

        public Criteria andFengineGreaterThanOrEqualTo(String value) {
            addCriterion("fEngine >=", value, "fengine");
            return (Criteria) this;
        }

        public Criteria andFengineLessThan(String value) {
            addCriterion("fEngine <", value, "fengine");
            return (Criteria) this;
        }

        public Criteria andFengineLessThanOrEqualTo(String value) {
            addCriterion("fEngine <=", value, "fengine");
            return (Criteria) this;
        }

        public Criteria andFengineLike(String value) {
            addCriterion("fEngine like", value, "fengine");
            return (Criteria) this;
        }

        public Criteria andFengineNotLike(String value) {
            addCriterion("fEngine not like", value, "fengine");
            return (Criteria) this;
        }

        public Criteria andFengineIn(List<String> values) {
            addCriterion("fEngine in", values, "fengine");
            return (Criteria) this;
        }

        public Criteria andFengineNotIn(List<String> values) {
            addCriterion("fEngine not in", values, "fengine");
            return (Criteria) this;
        }

        public Criteria andFengineBetween(String value1, String value2) {
            addCriterion("fEngine between", value1, value2, "fengine");
            return (Criteria) this;
        }

        public Criteria andFengineNotBetween(String value1, String value2) {
            addCriterion("fEngine not between", value1, value2, "fengine");
            return (Criteria) this;
        }

        public Criteria andFbplandateIsNull() {
            addCriterion("fBPlanDate is null");
            return (Criteria) this;
        }

        public Criteria andFbplandateIsNotNull() {
            addCriterion("fBPlanDate is not null");
            return (Criteria) this;
        }

        public Criteria andFbplandateEqualTo(Date value) {
            addCriterion("fBPlanDate =", value, "fbplandate");
            return (Criteria) this;
        }

        public Criteria andFbplandateNotEqualTo(Date value) {
            addCriterion("fBPlanDate <>", value, "fbplandate");
            return (Criteria) this;
        }

        public Criteria andFbplandateGreaterThan(Date value) {
            addCriterion("fBPlanDate >", value, "fbplandate");
            return (Criteria) this;
        }

        public Criteria andFbplandateGreaterThanOrEqualTo(Date value) {
            addCriterion("fBPlanDate >=", value, "fbplandate");
            return (Criteria) this;
        }

        public Criteria andFbplandateLessThan(Date value) {
            addCriterion("fBPlanDate <", value, "fbplandate");
            return (Criteria) this;
        }

        public Criteria andFbplandateLessThanOrEqualTo(Date value) {
            addCriterion("fBPlanDate <=", value, "fbplandate");
            return (Criteria) this;
        }

        public Criteria andFbplandateIn(List<Date> values) {
            addCriterion("fBPlanDate in", values, "fbplandate");
            return (Criteria) this;
        }

        public Criteria andFbplandateNotIn(List<Date> values) {
            addCriterion("fBPlanDate not in", values, "fbplandate");
            return (Criteria) this;
        }

        public Criteria andFbplandateBetween(Date value1, Date value2) {
            addCriterion("fBPlanDate between", value1, value2, "fbplandate");
            return (Criteria) this;
        }

        public Criteria andFbplandateNotBetween(Date value1, Date value2) {
            addCriterion("fBPlanDate not between", value1, value2, "fbplandate");
            return (Criteria) this;
        }

        public Criteria andFeplandateIsNull() {
            addCriterion("fEPlanDate is null");
            return (Criteria) this;
        }

        public Criteria andFeplandateIsNotNull() {
            addCriterion("fEPlanDate is not null");
            return (Criteria) this;
        }

        public Criteria andFeplandateEqualTo(Date value) {
            addCriterion("fEPlanDate =", value, "feplandate");
            return (Criteria) this;
        }

        public Criteria andFeplandateNotEqualTo(Date value) {
            addCriterion("fEPlanDate <>", value, "feplandate");
            return (Criteria) this;
        }

        public Criteria andFeplandateGreaterThan(Date value) {
            addCriterion("fEPlanDate >", value, "feplandate");
            return (Criteria) this;
        }

        public Criteria andFeplandateGreaterThanOrEqualTo(Date value) {
            addCriterion("fEPlanDate >=", value, "feplandate");
            return (Criteria) this;
        }

        public Criteria andFeplandateLessThan(Date value) {
            addCriterion("fEPlanDate <", value, "feplandate");
            return (Criteria) this;
        }

        public Criteria andFeplandateLessThanOrEqualTo(Date value) {
            addCriterion("fEPlanDate <=", value, "feplandate");
            return (Criteria) this;
        }

        public Criteria andFeplandateIn(List<Date> values) {
            addCriterion("fEPlanDate in", values, "feplandate");
            return (Criteria) this;
        }

        public Criteria andFeplandateNotIn(List<Date> values) {
            addCriterion("fEPlanDate not in", values, "feplandate");
            return (Criteria) this;
        }

        public Criteria andFeplandateBetween(Date value1, Date value2) {
            addCriterion("fEPlanDate between", value1, value2, "feplandate");
            return (Criteria) this;
        }

        public Criteria andFeplandateNotBetween(Date value1, Date value2) {
            addCriterion("fEPlanDate not between", value1, value2, "feplandate");
            return (Criteria) this;
        }

        public Criteria andFtotalpriceIsNull() {
            addCriterion("fTotalPrice is null");
            return (Criteria) this;
        }

        public Criteria andFtotalpriceIsNotNull() {
            addCriterion("fTotalPrice is not null");
            return (Criteria) this;
        }

        public Criteria andFtotalpriceEqualTo(BigDecimal value) {
            addCriterion("fTotalPrice =", value, "ftotalprice");
            return (Criteria) this;
        }

        public Criteria andFtotalpriceNotEqualTo(BigDecimal value) {
            addCriterion("fTotalPrice <>", value, "ftotalprice");
            return (Criteria) this;
        }

        public Criteria andFtotalpriceGreaterThan(BigDecimal value) {
            addCriterion("fTotalPrice >", value, "ftotalprice");
            return (Criteria) this;
        }

        public Criteria andFtotalpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fTotalPrice >=", value, "ftotalprice");
            return (Criteria) this;
        }

        public Criteria andFtotalpriceLessThan(BigDecimal value) {
            addCriterion("fTotalPrice <", value, "ftotalprice");
            return (Criteria) this;
        }

        public Criteria andFtotalpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fTotalPrice <=", value, "ftotalprice");
            return (Criteria) this;
        }

        public Criteria andFtotalpriceIn(List<BigDecimal> values) {
            addCriterion("fTotalPrice in", values, "ftotalprice");
            return (Criteria) this;
        }

        public Criteria andFtotalpriceNotIn(List<BigDecimal> values) {
            addCriterion("fTotalPrice not in", values, "ftotalprice");
            return (Criteria) this;
        }

        public Criteria andFtotalpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fTotalPrice between", value1, value2, "ftotalprice");
            return (Criteria) this;
        }

        public Criteria andFtotalpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fTotalPrice not between", value1, value2, "ftotalprice");
            return (Criteria) this;
        }

        public Criteria andFloanpriceIsNull() {
            addCriterion("fLoanPrice is null");
            return (Criteria) this;
        }

        public Criteria andFloanpriceIsNotNull() {
            addCriterion("fLoanPrice is not null");
            return (Criteria) this;
        }

        public Criteria andFloanpriceEqualTo(BigDecimal value) {
            addCriterion("fLoanPrice =", value, "floanprice");
            return (Criteria) this;
        }

        public Criteria andFloanpriceNotEqualTo(BigDecimal value) {
            addCriterion("fLoanPrice <>", value, "floanprice");
            return (Criteria) this;
        }

        public Criteria andFloanpriceGreaterThan(BigDecimal value) {
            addCriterion("fLoanPrice >", value, "floanprice");
            return (Criteria) this;
        }

        public Criteria andFloanpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fLoanPrice >=", value, "floanprice");
            return (Criteria) this;
        }

        public Criteria andFloanpriceLessThan(BigDecimal value) {
            addCriterion("fLoanPrice <", value, "floanprice");
            return (Criteria) this;
        }

        public Criteria andFloanpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fLoanPrice <=", value, "floanprice");
            return (Criteria) this;
        }

        public Criteria andFloanpriceIn(List<BigDecimal> values) {
            addCriterion("fLoanPrice in", values, "floanprice");
            return (Criteria) this;
        }

        public Criteria andFloanpriceNotIn(List<BigDecimal> values) {
            addCriterion("fLoanPrice not in", values, "floanprice");
            return (Criteria) this;
        }

        public Criteria andFloanpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fLoanPrice between", value1, value2, "floanprice");
            return (Criteria) this;
        }

        public Criteria andFloanpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fLoanPrice not between", value1, value2, "floanprice");
            return (Criteria) this;
        }

        public Criteria andFstockstatusidIsNull() {
            addCriterion("fStockStatusID is null");
            return (Criteria) this;
        }

        public Criteria andFstockstatusidIsNotNull() {
            addCriterion("fStockStatusID is not null");
            return (Criteria) this;
        }

        public Criteria andFstockstatusidEqualTo(Integer value) {
            addCriterion("fStockStatusID =", value, "fstockstatusid");
            return (Criteria) this;
        }

        public Criteria andFstockstatusidNotEqualTo(Integer value) {
            addCriterion("fStockStatusID <>", value, "fstockstatusid");
            return (Criteria) this;
        }

        public Criteria andFstockstatusidGreaterThan(Integer value) {
            addCriterion("fStockStatusID >", value, "fstockstatusid");
            return (Criteria) this;
        }

        public Criteria andFstockstatusidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStockStatusID >=", value, "fstockstatusid");
            return (Criteria) this;
        }

        public Criteria andFstockstatusidLessThan(Integer value) {
            addCriterion("fStockStatusID <", value, "fstockstatusid");
            return (Criteria) this;
        }

        public Criteria andFstockstatusidLessThanOrEqualTo(Integer value) {
            addCriterion("fStockStatusID <=", value, "fstockstatusid");
            return (Criteria) this;
        }

        public Criteria andFstockstatusidIn(List<Integer> values) {
            addCriterion("fStockStatusID in", values, "fstockstatusid");
            return (Criteria) this;
        }

        public Criteria andFstockstatusidNotIn(List<Integer> values) {
            addCriterion("fStockStatusID not in", values, "fstockstatusid");
            return (Criteria) this;
        }

        public Criteria andFstockstatusidBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatusID between", value1, value2, "fstockstatusid");
            return (Criteria) this;
        }

        public Criteria andFstockstatusidNotBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatusID not between", value1, value2, "fstockstatusid");
            return (Criteria) this;
        }

        public Criteria andFstockstatus1idIsNull() {
            addCriterion("fStockStatus1ID is null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus1idIsNotNull() {
            addCriterion("fStockStatus1ID is not null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus1idEqualTo(Integer value) {
            addCriterion("fStockStatus1ID =", value, "fstockstatus1id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus1idNotEqualTo(Integer value) {
            addCriterion("fStockStatus1ID <>", value, "fstockstatus1id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus1idGreaterThan(Integer value) {
            addCriterion("fStockStatus1ID >", value, "fstockstatus1id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus1idGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus1ID >=", value, "fstockstatus1id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus1idLessThan(Integer value) {
            addCriterion("fStockStatus1ID <", value, "fstockstatus1id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus1idLessThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus1ID <=", value, "fstockstatus1id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus1idIn(List<Integer> values) {
            addCriterion("fStockStatus1ID in", values, "fstockstatus1id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus1idNotIn(List<Integer> values) {
            addCriterion("fStockStatus1ID not in", values, "fstockstatus1id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus1idBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus1ID between", value1, value2, "fstockstatus1id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus1idNotBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus1ID not between", value1, value2, "fstockstatus1id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus2idIsNull() {
            addCriterion("fStockStatus2ID is null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus2idIsNotNull() {
            addCriterion("fStockStatus2ID is not null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus2idEqualTo(Integer value) {
            addCriterion("fStockStatus2ID =", value, "fstockstatus2id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus2idNotEqualTo(Integer value) {
            addCriterion("fStockStatus2ID <>", value, "fstockstatus2id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus2idGreaterThan(Integer value) {
            addCriterion("fStockStatus2ID >", value, "fstockstatus2id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus2idGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus2ID >=", value, "fstockstatus2id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus2idLessThan(Integer value) {
            addCriterion("fStockStatus2ID <", value, "fstockstatus2id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus2idLessThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus2ID <=", value, "fstockstatus2id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus2idIn(List<Integer> values) {
            addCriterion("fStockStatus2ID in", values, "fstockstatus2id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus2idNotIn(List<Integer> values) {
            addCriterion("fStockStatus2ID not in", values, "fstockstatus2id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus2idBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus2ID between", value1, value2, "fstockstatus2id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus2idNotBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus2ID not between", value1, value2, "fstockstatus2id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus4idIsNull() {
            addCriterion("fStockStatus4ID is null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus4idIsNotNull() {
            addCriterion("fStockStatus4ID is not null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus4idEqualTo(Integer value) {
            addCriterion("fStockStatus4ID =", value, "fstockstatus4id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus4idNotEqualTo(Integer value) {
            addCriterion("fStockStatus4ID <>", value, "fstockstatus4id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus4idGreaterThan(Integer value) {
            addCriterion("fStockStatus4ID >", value, "fstockstatus4id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus4idGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus4ID >=", value, "fstockstatus4id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus4idLessThan(Integer value) {
            addCriterion("fStockStatus4ID <", value, "fstockstatus4id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus4idLessThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus4ID <=", value, "fstockstatus4id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus4idIn(List<Integer> values) {
            addCriterion("fStockStatus4ID in", values, "fstockstatus4id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus4idNotIn(List<Integer> values) {
            addCriterion("fStockStatus4ID not in", values, "fstockstatus4id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus4idBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus4ID between", value1, value2, "fstockstatus4id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus4idNotBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus4ID not between", value1, value2, "fstockstatus4id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus3idIsNull() {
            addCriterion("fStockStatus3ID is null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus3idIsNotNull() {
            addCriterion("fStockStatus3ID is not null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus3idEqualTo(Integer value) {
            addCriterion("fStockStatus3ID =", value, "fstockstatus3id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus3idNotEqualTo(Integer value) {
            addCriterion("fStockStatus3ID <>", value, "fstockstatus3id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus3idGreaterThan(Integer value) {
            addCriterion("fStockStatus3ID >", value, "fstockstatus3id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus3idGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus3ID >=", value, "fstockstatus3id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus3idLessThan(Integer value) {
            addCriterion("fStockStatus3ID <", value, "fstockstatus3id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus3idLessThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus3ID <=", value, "fstockstatus3id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus3idIn(List<Integer> values) {
            addCriterion("fStockStatus3ID in", values, "fstockstatus3id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus3idNotIn(List<Integer> values) {
            addCriterion("fStockStatus3ID not in", values, "fstockstatus3id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus3idBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus3ID between", value1, value2, "fstockstatus3id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus3idNotBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus3ID not between", value1, value2, "fstockstatus3id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus5idIsNull() {
            addCriterion("fStockStatus5ID is null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus5idIsNotNull() {
            addCriterion("fStockStatus5ID is not null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus5idEqualTo(Integer value) {
            addCriterion("fStockStatus5ID =", value, "fstockstatus5id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus5idNotEqualTo(Integer value) {
            addCriterion("fStockStatus5ID <>", value, "fstockstatus5id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus5idGreaterThan(Integer value) {
            addCriterion("fStockStatus5ID >", value, "fstockstatus5id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus5idGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus5ID >=", value, "fstockstatus5id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus5idLessThan(Integer value) {
            addCriterion("fStockStatus5ID <", value, "fstockstatus5id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus5idLessThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus5ID <=", value, "fstockstatus5id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus5idIn(List<Integer> values) {
            addCriterion("fStockStatus5ID in", values, "fstockstatus5id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus5idNotIn(List<Integer> values) {
            addCriterion("fStockStatus5ID not in", values, "fstockstatus5id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus5idBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus5ID between", value1, value2, "fstockstatus5id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus5idNotBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus5ID not between", value1, value2, "fstockstatus5id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus6idIsNull() {
            addCriterion("fStockStatus6ID is null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus6idIsNotNull() {
            addCriterion("fStockStatus6ID is not null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus6idEqualTo(Integer value) {
            addCriterion("fStockStatus6ID =", value, "fstockstatus6id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus6idNotEqualTo(Integer value) {
            addCriterion("fStockStatus6ID <>", value, "fstockstatus6id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus6idGreaterThan(Integer value) {
            addCriterion("fStockStatus6ID >", value, "fstockstatus6id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus6idGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus6ID >=", value, "fstockstatus6id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus6idLessThan(Integer value) {
            addCriterion("fStockStatus6ID <", value, "fstockstatus6id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus6idLessThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus6ID <=", value, "fstockstatus6id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus6idIn(List<Integer> values) {
            addCriterion("fStockStatus6ID in", values, "fstockstatus6id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus6idNotIn(List<Integer> values) {
            addCriterion("fStockStatus6ID not in", values, "fstockstatus6id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus6idBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus6ID between", value1, value2, "fstockstatus6id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus6idNotBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus6ID not between", value1, value2, "fstockstatus6id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus7idIsNull() {
            addCriterion("fStockStatus7ID is null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus7idIsNotNull() {
            addCriterion("fStockStatus7ID is not null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus7idEqualTo(Integer value) {
            addCriterion("fStockStatus7ID =", value, "fstockstatus7id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus7idNotEqualTo(Integer value) {
            addCriterion("fStockStatus7ID <>", value, "fstockstatus7id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus7idGreaterThan(Integer value) {
            addCriterion("fStockStatus7ID >", value, "fstockstatus7id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus7idGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus7ID >=", value, "fstockstatus7id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus7idLessThan(Integer value) {
            addCriterion("fStockStatus7ID <", value, "fstockstatus7id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus7idLessThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus7ID <=", value, "fstockstatus7id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus7idIn(List<Integer> values) {
            addCriterion("fStockStatus7ID in", values, "fstockstatus7id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus7idNotIn(List<Integer> values) {
            addCriterion("fStockStatus7ID not in", values, "fstockstatus7id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus7idBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus7ID between", value1, value2, "fstockstatus7id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus7idNotBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus7ID not between", value1, value2, "fstockstatus7id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus8idIsNull() {
            addCriterion("fStockStatus8ID is null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus8idIsNotNull() {
            addCriterion("fStockStatus8ID is not null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus8idEqualTo(Integer value) {
            addCriterion("fStockStatus8ID =", value, "fstockstatus8id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus8idNotEqualTo(Integer value) {
            addCriterion("fStockStatus8ID <>", value, "fstockstatus8id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus8idGreaterThan(Integer value) {
            addCriterion("fStockStatus8ID >", value, "fstockstatus8id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus8idGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus8ID >=", value, "fstockstatus8id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus8idLessThan(Integer value) {
            addCriterion("fStockStatus8ID <", value, "fstockstatus8id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus8idLessThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus8ID <=", value, "fstockstatus8id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus8idIn(List<Integer> values) {
            addCriterion("fStockStatus8ID in", values, "fstockstatus8id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus8idNotIn(List<Integer> values) {
            addCriterion("fStockStatus8ID not in", values, "fstockstatus8id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus8idBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus8ID between", value1, value2, "fstockstatus8id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus8idNotBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus8ID not between", value1, value2, "fstockstatus8id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus9idIsNull() {
            addCriterion("fStockStatus9ID is null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus9idIsNotNull() {
            addCriterion("fStockStatus9ID is not null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus9idEqualTo(Integer value) {
            addCriterion("fStockStatus9ID =", value, "fstockstatus9id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus9idNotEqualTo(Integer value) {
            addCriterion("fStockStatus9ID <>", value, "fstockstatus9id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus9idGreaterThan(Integer value) {
            addCriterion("fStockStatus9ID >", value, "fstockstatus9id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus9idGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus9ID >=", value, "fstockstatus9id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus9idLessThan(Integer value) {
            addCriterion("fStockStatus9ID <", value, "fstockstatus9id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus9idLessThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus9ID <=", value, "fstockstatus9id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus9idIn(List<Integer> values) {
            addCriterion("fStockStatus9ID in", values, "fstockstatus9id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus9idNotIn(List<Integer> values) {
            addCriterion("fStockStatus9ID not in", values, "fstockstatus9id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus9idBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus9ID between", value1, value2, "fstockstatus9id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus9idNotBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus9ID not between", value1, value2, "fstockstatus9id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus10idIsNull() {
            addCriterion("fStockStatus10ID is null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus10idIsNotNull() {
            addCriterion("fStockStatus10ID is not null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus10idEqualTo(Integer value) {
            addCriterion("fStockStatus10ID =", value, "fstockstatus10id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus10idNotEqualTo(Integer value) {
            addCriterion("fStockStatus10ID <>", value, "fstockstatus10id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus10idGreaterThan(Integer value) {
            addCriterion("fStockStatus10ID >", value, "fstockstatus10id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus10idGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus10ID >=", value, "fstockstatus10id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus10idLessThan(Integer value) {
            addCriterion("fStockStatus10ID <", value, "fstockstatus10id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus10idLessThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus10ID <=", value, "fstockstatus10id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus10idIn(List<Integer> values) {
            addCriterion("fStockStatus10ID in", values, "fstockstatus10id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus10idNotIn(List<Integer> values) {
            addCriterion("fStockStatus10ID not in", values, "fstockstatus10id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus10idBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus10ID between", value1, value2, "fstockstatus10id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus10idNotBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus10ID not between", value1, value2, "fstockstatus10id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus11idIsNull() {
            addCriterion("fStockStatus11ID is null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus11idIsNotNull() {
            addCriterion("fStockStatus11ID is not null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus11idEqualTo(Integer value) {
            addCriterion("fStockStatus11ID =", value, "fstockstatus11id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus11idNotEqualTo(Integer value) {
            addCriterion("fStockStatus11ID <>", value, "fstockstatus11id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus11idGreaterThan(Integer value) {
            addCriterion("fStockStatus11ID >", value, "fstockstatus11id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus11idGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus11ID >=", value, "fstockstatus11id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus11idLessThan(Integer value) {
            addCriterion("fStockStatus11ID <", value, "fstockstatus11id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus11idLessThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus11ID <=", value, "fstockstatus11id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus11idIn(List<Integer> values) {
            addCriterion("fStockStatus11ID in", values, "fstockstatus11id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus11idNotIn(List<Integer> values) {
            addCriterion("fStockStatus11ID not in", values, "fstockstatus11id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus11idBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus11ID between", value1, value2, "fstockstatus11id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus11idNotBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus11ID not between", value1, value2, "fstockstatus11id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus12idIsNull() {
            addCriterion("fStockStatus12ID is null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus12idIsNotNull() {
            addCriterion("fStockStatus12ID is not null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus12idEqualTo(Integer value) {
            addCriterion("fStockStatus12ID =", value, "fstockstatus12id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus12idNotEqualTo(Integer value) {
            addCriterion("fStockStatus12ID <>", value, "fstockstatus12id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus12idGreaterThan(Integer value) {
            addCriterion("fStockStatus12ID >", value, "fstockstatus12id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus12idGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus12ID >=", value, "fstockstatus12id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus12idLessThan(Integer value) {
            addCriterion("fStockStatus12ID <", value, "fstockstatus12id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus12idLessThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus12ID <=", value, "fstockstatus12id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus12idIn(List<Integer> values) {
            addCriterion("fStockStatus12ID in", values, "fstockstatus12id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus12idNotIn(List<Integer> values) {
            addCriterion("fStockStatus12ID not in", values, "fstockstatus12id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus12idBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus12ID between", value1, value2, "fstockstatus12id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus12idNotBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus12ID not between", value1, value2, "fstockstatus12id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus13idIsNull() {
            addCriterion("fStockStatus13ID is null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus13idIsNotNull() {
            addCriterion("fStockStatus13ID is not null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus13idEqualTo(Integer value) {
            addCriterion("fStockStatus13ID =", value, "fstockstatus13id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus13idNotEqualTo(Integer value) {
            addCriterion("fStockStatus13ID <>", value, "fstockstatus13id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus13idGreaterThan(Integer value) {
            addCriterion("fStockStatus13ID >", value, "fstockstatus13id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus13idGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus13ID >=", value, "fstockstatus13id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus13idLessThan(Integer value) {
            addCriterion("fStockStatus13ID <", value, "fstockstatus13id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus13idLessThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus13ID <=", value, "fstockstatus13id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus13idIn(List<Integer> values) {
            addCriterion("fStockStatus13ID in", values, "fstockstatus13id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus13idNotIn(List<Integer> values) {
            addCriterion("fStockStatus13ID not in", values, "fstockstatus13id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus13idBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus13ID between", value1, value2, "fstockstatus13id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus13idNotBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus13ID not between", value1, value2, "fstockstatus13id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus14idIsNull() {
            addCriterion("fStockStatus14ID is null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus14idIsNotNull() {
            addCriterion("fStockStatus14ID is not null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus14idEqualTo(Integer value) {
            addCriterion("fStockStatus14ID =", value, "fstockstatus14id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus14idNotEqualTo(Integer value) {
            addCriterion("fStockStatus14ID <>", value, "fstockstatus14id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus14idGreaterThan(Integer value) {
            addCriterion("fStockStatus14ID >", value, "fstockstatus14id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus14idGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus14ID >=", value, "fstockstatus14id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus14idLessThan(Integer value) {
            addCriterion("fStockStatus14ID <", value, "fstockstatus14id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus14idLessThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus14ID <=", value, "fstockstatus14id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus14idIn(List<Integer> values) {
            addCriterion("fStockStatus14ID in", values, "fstockstatus14id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus14idNotIn(List<Integer> values) {
            addCriterion("fStockStatus14ID not in", values, "fstockstatus14id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus14idBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus14ID between", value1, value2, "fstockstatus14id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus14idNotBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus14ID not between", value1, value2, "fstockstatus14id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus15idIsNull() {
            addCriterion("fStockStatus15ID is null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus15idIsNotNull() {
            addCriterion("fStockStatus15ID is not null");
            return (Criteria) this;
        }

        public Criteria andFstockstatus15idEqualTo(Integer value) {
            addCriterion("fStockStatus15ID =", value, "fstockstatus15id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus15idNotEqualTo(Integer value) {
            addCriterion("fStockStatus15ID <>", value, "fstockstatus15id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus15idGreaterThan(Integer value) {
            addCriterion("fStockStatus15ID >", value, "fstockstatus15id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus15idGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus15ID >=", value, "fstockstatus15id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus15idLessThan(Integer value) {
            addCriterion("fStockStatus15ID <", value, "fstockstatus15id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus15idLessThanOrEqualTo(Integer value) {
            addCriterion("fStockStatus15ID <=", value, "fstockstatus15id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus15idIn(List<Integer> values) {
            addCriterion("fStockStatus15ID in", values, "fstockstatus15id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus15idNotIn(List<Integer> values) {
            addCriterion("fStockStatus15ID not in", values, "fstockstatus15id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus15idBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus15ID between", value1, value2, "fstockstatus15id");
            return (Criteria) this;
        }

        public Criteria andFstockstatus15idNotBetween(Integer value1, Integer value2) {
            addCriterion("fStockStatus15ID not between", value1, value2, "fstockstatus15id");
            return (Criteria) this;
        }

        public Criteria andFcheckqualityIsNull() {
            addCriterion("fCheckQuality is null");
            return (Criteria) this;
        }

        public Criteria andFcheckqualityIsNotNull() {
            addCriterion("fCheckQuality is not null");
            return (Criteria) this;
        }

        public Criteria andFcheckqualityEqualTo(BigDecimal value) {
            addCriterion("fCheckQuality =", value, "fcheckquality");
            return (Criteria) this;
        }

        public Criteria andFcheckqualityNotEqualTo(BigDecimal value) {
            addCriterion("fCheckQuality <>", value, "fcheckquality");
            return (Criteria) this;
        }

        public Criteria andFcheckqualityGreaterThan(BigDecimal value) {
            addCriterion("fCheckQuality >", value, "fcheckquality");
            return (Criteria) this;
        }

        public Criteria andFcheckqualityGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fCheckQuality >=", value, "fcheckquality");
            return (Criteria) this;
        }

        public Criteria andFcheckqualityLessThan(BigDecimal value) {
            addCriterion("fCheckQuality <", value, "fcheckquality");
            return (Criteria) this;
        }

        public Criteria andFcheckqualityLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fCheckQuality <=", value, "fcheckquality");
            return (Criteria) this;
        }

        public Criteria andFcheckqualityIn(List<BigDecimal> values) {
            addCriterion("fCheckQuality in", values, "fcheckquality");
            return (Criteria) this;
        }

        public Criteria andFcheckqualityNotIn(List<BigDecimal> values) {
            addCriterion("fCheckQuality not in", values, "fcheckquality");
            return (Criteria) this;
        }

        public Criteria andFcheckqualityBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fCheckQuality between", value1, value2, "fcheckquality");
            return (Criteria) this;
        }

        public Criteria andFcheckqualityNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fCheckQuality not between", value1, value2, "fcheckquality");
            return (Criteria) this;
        }

        public Criteria andFgtonnageIsNull() {
            addCriterion("fGTonnage is null");
            return (Criteria) this;
        }

        public Criteria andFgtonnageIsNotNull() {
            addCriterion("fGTonnage is not null");
            return (Criteria) this;
        }

        public Criteria andFgtonnageEqualTo(BigDecimal value) {
            addCriterion("fGTonnage =", value, "fgtonnage");
            return (Criteria) this;
        }

        public Criteria andFgtonnageNotEqualTo(BigDecimal value) {
            addCriterion("fGTonnage <>", value, "fgtonnage");
            return (Criteria) this;
        }

        public Criteria andFgtonnageGreaterThan(BigDecimal value) {
            addCriterion("fGTonnage >", value, "fgtonnage");
            return (Criteria) this;
        }

        public Criteria andFgtonnageGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fGTonnage >=", value, "fgtonnage");
            return (Criteria) this;
        }

        public Criteria andFgtonnageLessThan(BigDecimal value) {
            addCriterion("fGTonnage <", value, "fgtonnage");
            return (Criteria) this;
        }

        public Criteria andFgtonnageLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fGTonnage <=", value, "fgtonnage");
            return (Criteria) this;
        }

        public Criteria andFgtonnageIn(List<BigDecimal> values) {
            addCriterion("fGTonnage in", values, "fgtonnage");
            return (Criteria) this;
        }

        public Criteria andFgtonnageNotIn(List<BigDecimal> values) {
            addCriterion("fGTonnage not in", values, "fgtonnage");
            return (Criteria) this;
        }

        public Criteria andFgtonnageBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fGTonnage between", value1, value2, "fgtonnage");
            return (Criteria) this;
        }

        public Criteria andFgtonnageNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fGTonnage not between", value1, value2, "fgtonnage");
            return (Criteria) this;
        }

        public Criteria andFmtonnageIsNull() {
            addCriterion("fMTonnage is null");
            return (Criteria) this;
        }

        public Criteria andFmtonnageIsNotNull() {
            addCriterion("fMTonnage is not null");
            return (Criteria) this;
        }

        public Criteria andFmtonnageEqualTo(BigDecimal value) {
            addCriterion("fMTonnage =", value, "fmtonnage");
            return (Criteria) this;
        }

        public Criteria andFmtonnageNotEqualTo(BigDecimal value) {
            addCriterion("fMTonnage <>", value, "fmtonnage");
            return (Criteria) this;
        }

        public Criteria andFmtonnageGreaterThan(BigDecimal value) {
            addCriterion("fMTonnage >", value, "fmtonnage");
            return (Criteria) this;
        }

        public Criteria andFmtonnageGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fMTonnage >=", value, "fmtonnage");
            return (Criteria) this;
        }

        public Criteria andFmtonnageLessThan(BigDecimal value) {
            addCriterion("fMTonnage <", value, "fmtonnage");
            return (Criteria) this;
        }

        public Criteria andFmtonnageLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fMTonnage <=", value, "fmtonnage");
            return (Criteria) this;
        }

        public Criteria andFmtonnageIn(List<BigDecimal> values) {
            addCriterion("fMTonnage in", values, "fmtonnage");
            return (Criteria) this;
        }

        public Criteria andFmtonnageNotIn(List<BigDecimal> values) {
            addCriterion("fMTonnage not in", values, "fmtonnage");
            return (Criteria) this;
        }

        public Criteria andFmtonnageBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fMTonnage between", value1, value2, "fmtonnage");
            return (Criteria) this;
        }

        public Criteria andFmtonnageNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fMTonnage not between", value1, value2, "fmtonnage");
            return (Criteria) this;
        }

        public Criteria andFscompanyidIsNull() {
            addCriterion("fSCompanyID is null");
            return (Criteria) this;
        }

        public Criteria andFscompanyidIsNotNull() {
            addCriterion("fSCompanyID is not null");
            return (Criteria) this;
        }

        public Criteria andFscompanyidEqualTo(Integer value) {
            addCriterion("fSCompanyID =", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidNotEqualTo(Integer value) {
            addCriterion("fSCompanyID <>", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidGreaterThan(Integer value) {
            addCriterion("fSCompanyID >", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fSCompanyID >=", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidLessThan(Integer value) {
            addCriterion("fSCompanyID <", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidLessThanOrEqualTo(Integer value) {
            addCriterion("fSCompanyID <=", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidIn(List<Integer> values) {
            addCriterion("fSCompanyID in", values, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidNotIn(List<Integer> values) {
            addCriterion("fSCompanyID not in", values, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidBetween(Integer value1, Integer value2) {
            addCriterion("fSCompanyID between", value1, value2, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidNotBetween(Integer value1, Integer value2) {
            addCriterion("fSCompanyID not between", value1, value2, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFmakemodelidIsNull() {
            addCriterion("fMakeModelID is null");
            return (Criteria) this;
        }

        public Criteria andFmakemodelidIsNotNull() {
            addCriterion("fMakeModelID is not null");
            return (Criteria) this;
        }

        public Criteria andFmakemodelidEqualTo(Integer value) {
            addCriterion("fMakeModelID =", value, "fmakemodelid");
            return (Criteria) this;
        }

        public Criteria andFmakemodelidNotEqualTo(Integer value) {
            addCriterion("fMakeModelID <>", value, "fmakemodelid");
            return (Criteria) this;
        }

        public Criteria andFmakemodelidGreaterThan(Integer value) {
            addCriterion("fMakeModelID >", value, "fmakemodelid");
            return (Criteria) this;
        }

        public Criteria andFmakemodelidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fMakeModelID >=", value, "fmakemodelid");
            return (Criteria) this;
        }

        public Criteria andFmakemodelidLessThan(Integer value) {
            addCriterion("fMakeModelID <", value, "fmakemodelid");
            return (Criteria) this;
        }

        public Criteria andFmakemodelidLessThanOrEqualTo(Integer value) {
            addCriterion("fMakeModelID <=", value, "fmakemodelid");
            return (Criteria) this;
        }

        public Criteria andFmakemodelidIn(List<Integer> values) {
            addCriterion("fMakeModelID in", values, "fmakemodelid");
            return (Criteria) this;
        }

        public Criteria andFmakemodelidNotIn(List<Integer> values) {
            addCriterion("fMakeModelID not in", values, "fmakemodelid");
            return (Criteria) this;
        }

        public Criteria andFmakemodelidBetween(Integer value1, Integer value2) {
            addCriterion("fMakeModelID between", value1, value2, "fmakemodelid");
            return (Criteria) this;
        }

        public Criteria andFmakemodelidNotBetween(Integer value1, Integer value2) {
            addCriterion("fMakeModelID not between", value1, value2, "fmakemodelid");
            return (Criteria) this;
        }

        public Criteria andFallqualityIsNull() {
            addCriterion("fAllQuality is null");
            return (Criteria) this;
        }

        public Criteria andFallqualityIsNotNull() {
            addCriterion("fAllQuality is not null");
            return (Criteria) this;
        }

        public Criteria andFallqualityEqualTo(BigDecimal value) {
            addCriterion("fAllQuality =", value, "fallquality");
            return (Criteria) this;
        }

        public Criteria andFallqualityNotEqualTo(BigDecimal value) {
            addCriterion("fAllQuality <>", value, "fallquality");
            return (Criteria) this;
        }

        public Criteria andFallqualityGreaterThan(BigDecimal value) {
            addCriterion("fAllQuality >", value, "fallquality");
            return (Criteria) this;
        }

        public Criteria andFallqualityGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fAllQuality >=", value, "fallquality");
            return (Criteria) this;
        }

        public Criteria andFallqualityLessThan(BigDecimal value) {
            addCriterion("fAllQuality <", value, "fallquality");
            return (Criteria) this;
        }

        public Criteria andFallqualityLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fAllQuality <=", value, "fallquality");
            return (Criteria) this;
        }

        public Criteria andFallqualityIn(List<BigDecimal> values) {
            addCriterion("fAllQuality in", values, "fallquality");
            return (Criteria) this;
        }

        public Criteria andFallqualityNotIn(List<BigDecimal> values) {
            addCriterion("fAllQuality not in", values, "fallquality");
            return (Criteria) this;
        }

        public Criteria andFallqualityBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fAllQuality between", value1, value2, "fallquality");
            return (Criteria) this;
        }

        public Criteria andFallqualityNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fAllQuality not between", value1, value2, "fallquality");
            return (Criteria) this;
        }

        public Criteria andFuseidIsNull() {
            addCriterion("fUseID is null");
            return (Criteria) this;
        }

        public Criteria andFuseidIsNotNull() {
            addCriterion("fUseID is not null");
            return (Criteria) this;
        }

        public Criteria andFuseidEqualTo(Integer value) {
            addCriterion("fUseID =", value, "fuseid");
            return (Criteria) this;
        }

        public Criteria andFuseidNotEqualTo(Integer value) {
            addCriterion("fUseID <>", value, "fuseid");
            return (Criteria) this;
        }

        public Criteria andFuseidGreaterThan(Integer value) {
            addCriterion("fUseID >", value, "fuseid");
            return (Criteria) this;
        }

        public Criteria andFuseidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fUseID >=", value, "fuseid");
            return (Criteria) this;
        }

        public Criteria andFuseidLessThan(Integer value) {
            addCriterion("fUseID <", value, "fuseid");
            return (Criteria) this;
        }

        public Criteria andFuseidLessThanOrEqualTo(Integer value) {
            addCriterion("fUseID <=", value, "fuseid");
            return (Criteria) this;
        }

        public Criteria andFuseidIn(List<Integer> values) {
            addCriterion("fUseID in", values, "fuseid");
            return (Criteria) this;
        }

        public Criteria andFuseidNotIn(List<Integer> values) {
            addCriterion("fUseID not in", values, "fuseid");
            return (Criteria) this;
        }

        public Criteria andFuseidBetween(Integer value1, Integer value2) {
            addCriterion("fUseID between", value1, value2, "fuseid");
            return (Criteria) this;
        }

        public Criteria andFuseidNotBetween(Integer value1, Integer value2) {
            addCriterion("fUseID not between", value1, value2, "fuseid");
            return (Criteria) this;
        }

        public Criteria andFgpstypeidIsNull() {
            addCriterion("fGpsTypeID is null");
            return (Criteria) this;
        }

        public Criteria andFgpstypeidIsNotNull() {
            addCriterion("fGpsTypeID is not null");
            return (Criteria) this;
        }

        public Criteria andFgpstypeidEqualTo(Integer value) {
            addCriterion("fGpsTypeID =", value, "fgpstypeid");
            return (Criteria) this;
        }

        public Criteria andFgpstypeidNotEqualTo(Integer value) {
            addCriterion("fGpsTypeID <>", value, "fgpstypeid");
            return (Criteria) this;
        }

        public Criteria andFgpstypeidGreaterThan(Integer value) {
            addCriterion("fGpsTypeID >", value, "fgpstypeid");
            return (Criteria) this;
        }

        public Criteria andFgpstypeidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fGpsTypeID >=", value, "fgpstypeid");
            return (Criteria) this;
        }

        public Criteria andFgpstypeidLessThan(Integer value) {
            addCriterion("fGpsTypeID <", value, "fgpstypeid");
            return (Criteria) this;
        }

        public Criteria andFgpstypeidLessThanOrEqualTo(Integer value) {
            addCriterion("fGpsTypeID <=", value, "fgpstypeid");
            return (Criteria) this;
        }

        public Criteria andFgpstypeidIn(List<Integer> values) {
            addCriterion("fGpsTypeID in", values, "fgpstypeid");
            return (Criteria) this;
        }

        public Criteria andFgpstypeidNotIn(List<Integer> values) {
            addCriterion("fGpsTypeID not in", values, "fgpstypeid");
            return (Criteria) this;
        }

        public Criteria andFgpstypeidBetween(Integer value1, Integer value2) {
            addCriterion("fGpsTypeID between", value1, value2, "fgpstypeid");
            return (Criteria) this;
        }

        public Criteria andFgpstypeidNotBetween(Integer value1, Integer value2) {
            addCriterion("fGpsTypeID not between", value1, value2, "fgpstypeid");
            return (Criteria) this;
        }

        public Criteria andFgpsnoIsNull() {
            addCriterion("fGpsNO is null");
            return (Criteria) this;
        }

        public Criteria andFgpsnoIsNotNull() {
            addCriterion("fGpsNO is not null");
            return (Criteria) this;
        }

        public Criteria andFgpsnoEqualTo(String value) {
            addCriterion("fGpsNO =", value, "fgpsno");
            return (Criteria) this;
        }

        public Criteria andFgpsnoNotEqualTo(String value) {
            addCriterion("fGpsNO <>", value, "fgpsno");
            return (Criteria) this;
        }

        public Criteria andFgpsnoGreaterThan(String value) {
            addCriterion("fGpsNO >", value, "fgpsno");
            return (Criteria) this;
        }

        public Criteria andFgpsnoGreaterThanOrEqualTo(String value) {
            addCriterion("fGpsNO >=", value, "fgpsno");
            return (Criteria) this;
        }

        public Criteria andFgpsnoLessThan(String value) {
            addCriterion("fGpsNO <", value, "fgpsno");
            return (Criteria) this;
        }

        public Criteria andFgpsnoLessThanOrEqualTo(String value) {
            addCriterion("fGpsNO <=", value, "fgpsno");
            return (Criteria) this;
        }

        public Criteria andFgpsnoLike(String value) {
            addCriterion("fGpsNO like", value, "fgpsno");
            return (Criteria) this;
        }

        public Criteria andFgpsnoNotLike(String value) {
            addCriterion("fGpsNO not like", value, "fgpsno");
            return (Criteria) this;
        }

        public Criteria andFgpsnoIn(List<String> values) {
            addCriterion("fGpsNO in", values, "fgpsno");
            return (Criteria) this;
        }

        public Criteria andFgpsnoNotIn(List<String> values) {
            addCriterion("fGpsNO not in", values, "fgpsno");
            return (Criteria) this;
        }

        public Criteria andFgpsnoBetween(String value1, String value2) {
            addCriterion("fGpsNO between", value1, value2, "fgpsno");
            return (Criteria) this;
        }

        public Criteria andFgpsnoNotBetween(String value1, String value2) {
            addCriterion("fGpsNO not between", value1, value2, "fgpsno");
            return (Criteria) this;
        }

        public Criteria andFregisternoIsNull() {
            addCriterion("fRegisterNO is null");
            return (Criteria) this;
        }

        public Criteria andFregisternoIsNotNull() {
            addCriterion("fRegisterNO is not null");
            return (Criteria) this;
        }

        public Criteria andFregisternoEqualTo(String value) {
            addCriterion("fRegisterNO =", value, "fregisterno");
            return (Criteria) this;
        }

        public Criteria andFregisternoNotEqualTo(String value) {
            addCriterion("fRegisterNO <>", value, "fregisterno");
            return (Criteria) this;
        }

        public Criteria andFregisternoGreaterThan(String value) {
            addCriterion("fRegisterNO >", value, "fregisterno");
            return (Criteria) this;
        }

        public Criteria andFregisternoGreaterThanOrEqualTo(String value) {
            addCriterion("fRegisterNO >=", value, "fregisterno");
            return (Criteria) this;
        }

        public Criteria andFregisternoLessThan(String value) {
            addCriterion("fRegisterNO <", value, "fregisterno");
            return (Criteria) this;
        }

        public Criteria andFregisternoLessThanOrEqualTo(String value) {
            addCriterion("fRegisterNO <=", value, "fregisterno");
            return (Criteria) this;
        }

        public Criteria andFregisternoLike(String value) {
            addCriterion("fRegisterNO like", value, "fregisterno");
            return (Criteria) this;
        }

        public Criteria andFregisternoNotLike(String value) {
            addCriterion("fRegisterNO not like", value, "fregisterno");
            return (Criteria) this;
        }

        public Criteria andFregisternoIn(List<String> values) {
            addCriterion("fRegisterNO in", values, "fregisterno");
            return (Criteria) this;
        }

        public Criteria andFregisternoNotIn(List<String> values) {
            addCriterion("fRegisterNO not in", values, "fregisterno");
            return (Criteria) this;
        }

        public Criteria andFregisternoBetween(String value1, String value2) {
            addCriterion("fRegisterNO between", value1, value2, "fregisterno");
            return (Criteria) this;
        }

        public Criteria andFregisternoNotBetween(String value1, String value2) {
            addCriterion("fRegisterNO not between", value1, value2, "fregisterno");
            return (Criteria) this;
        }

        public Criteria andFinteridIsNull() {
            addCriterion("fInterID is null");
            return (Criteria) this;
        }

        public Criteria andFinteridIsNotNull() {
            addCriterion("fInterID is not null");
            return (Criteria) this;
        }

        public Criteria andFinteridEqualTo(Integer value) {
            addCriterion("fInterID =", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridNotEqualTo(Integer value) {
            addCriterion("fInterID <>", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridGreaterThan(Integer value) {
            addCriterion("fInterID >", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridGreaterThanOrEqualTo(Integer value) {
            addCriterion("fInterID >=", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridLessThan(Integer value) {
            addCriterion("fInterID <", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridLessThanOrEqualTo(Integer value) {
            addCriterion("fInterID <=", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridIn(List<Integer> values) {
            addCriterion("fInterID in", values, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridNotIn(List<Integer> values) {
            addCriterion("fInterID not in", values, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridBetween(Integer value1, Integer value2) {
            addCriterion("fInterID between", value1, value2, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridNotBetween(Integer value1, Integer value2) {
            addCriterion("fInterID not between", value1, value2, "finterid");
            return (Criteria) this;
        }

        public Criteria andFentryidIsNull() {
            addCriterion("fEntryID is null");
            return (Criteria) this;
        }

        public Criteria andFentryidIsNotNull() {
            addCriterion("fEntryID is not null");
            return (Criteria) this;
        }

        public Criteria andFentryidEqualTo(Integer value) {
            addCriterion("fEntryID =", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidNotEqualTo(Integer value) {
            addCriterion("fEntryID <>", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidGreaterThan(Integer value) {
            addCriterion("fEntryID >", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fEntryID >=", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidLessThan(Integer value) {
            addCriterion("fEntryID <", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidLessThanOrEqualTo(Integer value) {
            addCriterion("fEntryID <=", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidIn(List<Integer> values) {
            addCriterion("fEntryID in", values, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidNotIn(List<Integer> values) {
            addCriterion("fEntryID not in", values, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidBetween(Integer value1, Integer value2) {
            addCriterion("fEntryID between", value1, value2, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidNotBetween(Integer value1, Integer value2) {
            addCriterion("fEntryID not between", value1, value2, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFdateIsNull() {
            addCriterion("fDate is null");
            return (Criteria) this;
        }

        public Criteria andFdateIsNotNull() {
            addCriterion("fDate is not null");
            return (Criteria) this;
        }

        public Criteria andFdateEqualTo(Date value) {
            addCriterion("fDate =", value, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateNotEqualTo(Date value) {
            addCriterion("fDate <>", value, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateGreaterThan(Date value) {
            addCriterion("fDate >", value, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fDate >=", value, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateLessThan(Date value) {
            addCriterion("fDate <", value, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateLessThanOrEqualTo(Date value) {
            addCriterion("fDate <=", value, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateIn(List<Date> values) {
            addCriterion("fDate in", values, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateNotIn(List<Date> values) {
            addCriterion("fDate not in", values, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateBetween(Date value1, Date value2) {
            addCriterion("fDate between", value1, value2, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateNotBetween(Date value1, Date value2) {
            addCriterion("fDate not between", value1, value2, "fdate");
            return (Criteria) this;
        }

        public Criteria andFmbrandidIsNull() {
            addCriterion("fMBrandID is null");
            return (Criteria) this;
        }

        public Criteria andFmbrandidIsNotNull() {
            addCriterion("fMBrandID is not null");
            return (Criteria) this;
        }

        public Criteria andFmbrandidEqualTo(Integer value) {
            addCriterion("fMBrandID =", value, "fmbrandid");
            return (Criteria) this;
        }

        public Criteria andFmbrandidNotEqualTo(Integer value) {
            addCriterion("fMBrandID <>", value, "fmbrandid");
            return (Criteria) this;
        }

        public Criteria andFmbrandidGreaterThan(Integer value) {
            addCriterion("fMBrandID >", value, "fmbrandid");
            return (Criteria) this;
        }

        public Criteria andFmbrandidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fMBrandID >=", value, "fmbrandid");
            return (Criteria) this;
        }

        public Criteria andFmbrandidLessThan(Integer value) {
            addCriterion("fMBrandID <", value, "fmbrandid");
            return (Criteria) this;
        }

        public Criteria andFmbrandidLessThanOrEqualTo(Integer value) {
            addCriterion("fMBrandID <=", value, "fmbrandid");
            return (Criteria) this;
        }

        public Criteria andFmbrandidIn(List<Integer> values) {
            addCriterion("fMBrandID in", values, "fmbrandid");
            return (Criteria) this;
        }

        public Criteria andFmbrandidNotIn(List<Integer> values) {
            addCriterion("fMBrandID not in", values, "fmbrandid");
            return (Criteria) this;
        }

        public Criteria andFmbrandidBetween(Integer value1, Integer value2) {
            addCriterion("fMBrandID between", value1, value2, "fmbrandid");
            return (Criteria) this;
        }

        public Criteria andFmbrandidNotBetween(Integer value1, Integer value2) {
            addCriterion("fMBrandID not between", value1, value2, "fmbrandid");
            return (Criteria) this;
        }

        public Criteria andFmmodelIsNull() {
            addCriterion("fMModel is null");
            return (Criteria) this;
        }

        public Criteria andFmmodelIsNotNull() {
            addCriterion("fMModel is not null");
            return (Criteria) this;
        }

        public Criteria andFmmodelEqualTo(String value) {
            addCriterion("fMModel =", value, "fmmodel");
            return (Criteria) this;
        }

        public Criteria andFmmodelNotEqualTo(String value) {
            addCriterion("fMModel <>", value, "fmmodel");
            return (Criteria) this;
        }

        public Criteria andFmmodelGreaterThan(String value) {
            addCriterion("fMModel >", value, "fmmodel");
            return (Criteria) this;
        }

        public Criteria andFmmodelGreaterThanOrEqualTo(String value) {
            addCriterion("fMModel >=", value, "fmmodel");
            return (Criteria) this;
        }

        public Criteria andFmmodelLessThan(String value) {
            addCriterion("fMModel <", value, "fmmodel");
            return (Criteria) this;
        }

        public Criteria andFmmodelLessThanOrEqualTo(String value) {
            addCriterion("fMModel <=", value, "fmmodel");
            return (Criteria) this;
        }

        public Criteria andFmmodelLike(String value) {
            addCriterion("fMModel like", value, "fmmodel");
            return (Criteria) this;
        }

        public Criteria andFmmodelNotLike(String value) {
            addCriterion("fMModel not like", value, "fmmodel");
            return (Criteria) this;
        }

        public Criteria andFmmodelIn(List<String> values) {
            addCriterion("fMModel in", values, "fmmodel");
            return (Criteria) this;
        }

        public Criteria andFmmodelNotIn(List<String> values) {
            addCriterion("fMModel not in", values, "fmmodel");
            return (Criteria) this;
        }

        public Criteria andFmmodelBetween(String value1, String value2) {
            addCriterion("fMModel between", value1, value2, "fmmodel");
            return (Criteria) this;
        }

        public Criteria andFmmodelNotBetween(String value1, String value2) {
            addCriterion("fMModel not between", value1, value2, "fmmodel");
            return (Criteria) this;
        }

        public Criteria andFpailiangIsNull() {
            addCriterion("fPaiLiang is null");
            return (Criteria) this;
        }

        public Criteria andFpailiangIsNotNull() {
            addCriterion("fPaiLiang is not null");
            return (Criteria) this;
        }

        public Criteria andFpailiangEqualTo(BigDecimal value) {
            addCriterion("fPaiLiang =", value, "fpailiang");
            return (Criteria) this;
        }

        public Criteria andFpailiangNotEqualTo(BigDecimal value) {
            addCriterion("fPaiLiang <>", value, "fpailiang");
            return (Criteria) this;
        }

        public Criteria andFpailiangGreaterThan(BigDecimal value) {
            addCriterion("fPaiLiang >", value, "fpailiang");
            return (Criteria) this;
        }

        public Criteria andFpailiangGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fPaiLiang >=", value, "fpailiang");
            return (Criteria) this;
        }

        public Criteria andFpailiangLessThan(BigDecimal value) {
            addCriterion("fPaiLiang <", value, "fpailiang");
            return (Criteria) this;
        }

        public Criteria andFpailiangLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fPaiLiang <=", value, "fpailiang");
            return (Criteria) this;
        }

        public Criteria andFpailiangIn(List<BigDecimal> values) {
            addCriterion("fPaiLiang in", values, "fpailiang");
            return (Criteria) this;
        }

        public Criteria andFpailiangNotIn(List<BigDecimal> values) {
            addCriterion("fPaiLiang not in", values, "fpailiang");
            return (Criteria) this;
        }

        public Criteria andFpailiangBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fPaiLiang between", value1, value2, "fpailiang");
            return (Criteria) this;
        }

        public Criteria andFpailiangNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fPaiLiang not between", value1, value2, "fpailiang");
            return (Criteria) this;
        }

        public Criteria andFcreatoridIsNull() {
            addCriterion("fCreatorID is null");
            return (Criteria) this;
        }

        public Criteria andFcreatoridIsNotNull() {
            addCriterion("fCreatorID is not null");
            return (Criteria) this;
        }

        public Criteria andFcreatoridEqualTo(Integer value) {
            addCriterion("fCreatorID =", value, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridNotEqualTo(Integer value) {
            addCriterion("fCreatorID <>", value, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridGreaterThan(Integer value) {
            addCriterion("fCreatorID >", value, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridGreaterThanOrEqualTo(Integer value) {
            addCriterion("fCreatorID >=", value, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridLessThan(Integer value) {
            addCriterion("fCreatorID <", value, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridLessThanOrEqualTo(Integer value) {
            addCriterion("fCreatorID <=", value, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridIn(List<Integer> values) {
            addCriterion("fCreatorID in", values, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridNotIn(List<Integer> values) {
            addCriterion("fCreatorID not in", values, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridBetween(Integer value1, Integer value2) {
            addCriterion("fCreatorID between", value1, value2, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridNotBetween(Integer value1, Integer value2) {
            addCriterion("fCreatorID not between", value1, value2, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatedateIsNull() {
            addCriterion("fCreateDate is null");
            return (Criteria) this;
        }

        public Criteria andFcreatedateIsNotNull() {
            addCriterion("fCreateDate is not null");
            return (Criteria) this;
        }

        public Criteria andFcreatedateEqualTo(Date value) {
            addCriterion("fCreateDate =", value, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateNotEqualTo(Date value) {
            addCriterion("fCreateDate <>", value, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateGreaterThan(Date value) {
            addCriterion("fCreateDate >", value, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateGreaterThanOrEqualTo(Date value) {
            addCriterion("fCreateDate >=", value, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateLessThan(Date value) {
            addCriterion("fCreateDate <", value, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateLessThanOrEqualTo(Date value) {
            addCriterion("fCreateDate <=", value, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateIn(List<Date> values) {
            addCriterion("fCreateDate in", values, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateNotIn(List<Date> values) {
            addCriterion("fCreateDate not in", values, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateBetween(Date value1, Date value2) {
            addCriterion("fCreateDate between", value1, value2, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateNotBetween(Date value1, Date value2) {
            addCriterion("fCreateDate not between", value1, value2, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFmenderidIsNull() {
            addCriterion("fMenderID is null");
            return (Criteria) this;
        }

        public Criteria andFmenderidIsNotNull() {
            addCriterion("fMenderID is not null");
            return (Criteria) this;
        }

        public Criteria andFmenderidEqualTo(Integer value) {
            addCriterion("fMenderID =", value, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidNotEqualTo(Integer value) {
            addCriterion("fMenderID <>", value, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidGreaterThan(Integer value) {
            addCriterion("fMenderID >", value, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fMenderID >=", value, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidLessThan(Integer value) {
            addCriterion("fMenderID <", value, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidLessThanOrEqualTo(Integer value) {
            addCriterion("fMenderID <=", value, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidIn(List<Integer> values) {
            addCriterion("fMenderID in", values, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidNotIn(List<Integer> values) {
            addCriterion("fMenderID not in", values, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidBetween(Integer value1, Integer value2) {
            addCriterion("fMenderID between", value1, value2, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidNotBetween(Integer value1, Integer value2) {
            addCriterion("fMenderID not between", value1, value2, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFcheckdateIsNull() {
            addCriterion("fCheckDate is null");
            return (Criteria) this;
        }

        public Criteria andFcheckdateIsNotNull() {
            addCriterion("fCheckDate is not null");
            return (Criteria) this;
        }

        public Criteria andFcheckdateEqualTo(Date value) {
            addCriterion("fCheckDate =", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateNotEqualTo(Date value) {
            addCriterion("fCheckDate <>", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateGreaterThan(Date value) {
            addCriterion("fCheckDate >", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fCheckDate >=", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateLessThan(Date value) {
            addCriterion("fCheckDate <", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateLessThanOrEqualTo(Date value) {
            addCriterion("fCheckDate <=", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateIn(List<Date> values) {
            addCriterion("fCheckDate in", values, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateNotIn(List<Date> values) {
            addCriterion("fCheckDate not in", values, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateBetween(Date value1, Date value2) {
            addCriterion("fCheckDate between", value1, value2, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateNotBetween(Date value1, Date value2) {
            addCriterion("fCheckDate not between", value1, value2, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckeridIsNull() {
            addCriterion("fCheckerID is null");
            return (Criteria) this;
        }

        public Criteria andFcheckeridIsNotNull() {
            addCriterion("fCheckerID is not null");
            return (Criteria) this;
        }

        public Criteria andFcheckeridEqualTo(Integer value) {
            addCriterion("fCheckerID =", value, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridNotEqualTo(Integer value) {
            addCriterion("fCheckerID <>", value, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridGreaterThan(Integer value) {
            addCriterion("fCheckerID >", value, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridGreaterThanOrEqualTo(Integer value) {
            addCriterion("fCheckerID >=", value, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridLessThan(Integer value) {
            addCriterion("fCheckerID <", value, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridLessThanOrEqualTo(Integer value) {
            addCriterion("fCheckerID <=", value, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridIn(List<Integer> values) {
            addCriterion("fCheckerID in", values, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridNotIn(List<Integer> values) {
            addCriterion("fCheckerID not in", values, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridBetween(Integer value1, Integer value2) {
            addCriterion("fCheckerID between", value1, value2, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridNotBetween(Integer value1, Integer value2) {
            addCriterion("fCheckerID not between", value1, value2, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFmodifydateIsNull() {
            addCriterion("fModifyDate is null");
            return (Criteria) this;
        }

        public Criteria andFmodifydateIsNotNull() {
            addCriterion("fModifyDate is not null");
            return (Criteria) this;
        }

        public Criteria andFmodifydateEqualTo(Date value) {
            addCriterion("fModifyDate =", value, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateNotEqualTo(Date value) {
            addCriterion("fModifyDate <>", value, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateGreaterThan(Date value) {
            addCriterion("fModifyDate >", value, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateGreaterThanOrEqualTo(Date value) {
            addCriterion("fModifyDate >=", value, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateLessThan(Date value) {
            addCriterion("fModifyDate <", value, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateLessThanOrEqualTo(Date value) {
            addCriterion("fModifyDate <=", value, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateIn(List<Date> values) {
            addCriterion("fModifyDate in", values, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateNotIn(List<Date> values) {
            addCriterion("fModifyDate not in", values, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateBetween(Date value1, Date value2) {
            addCriterion("fModifyDate between", value1, value2, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateNotBetween(Date value1, Date value2) {
            addCriterion("fModifyDate not between", value1, value2, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFfullnameIsNull() {
            addCriterion("fFullName is null");
            return (Criteria) this;
        }

        public Criteria andFfullnameIsNotNull() {
            addCriterion("fFullName is not null");
            return (Criteria) this;
        }

        public Criteria andFfullnameEqualTo(String value) {
            addCriterion("fFullName =", value, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameNotEqualTo(String value) {
            addCriterion("fFullName <>", value, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameGreaterThan(String value) {
            addCriterion("fFullName >", value, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameGreaterThanOrEqualTo(String value) {
            addCriterion("fFullName >=", value, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameLessThan(String value) {
            addCriterion("fFullName <", value, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameLessThanOrEqualTo(String value) {
            addCriterion("fFullName <=", value, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameLike(String value) {
            addCriterion("fFullName like", value, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameNotLike(String value) {
            addCriterion("fFullName not like", value, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameIn(List<String> values) {
            addCriterion("fFullName in", values, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameNotIn(List<String> values) {
            addCriterion("fFullName not in", values, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameBetween(String value1, String value2) {
            addCriterion("fFullName between", value1, value2, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameNotBetween(String value1, String value2) {
            addCriterion("fFullName not between", value1, value2, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFspdateIsNull() {
            addCriterion("fSPDate is null");
            return (Criteria) this;
        }

        public Criteria andFspdateIsNotNull() {
            addCriterion("fSPDate is not null");
            return (Criteria) this;
        }

        public Criteria andFspdateEqualTo(Date value) {
            addCriterion("fSPDate =", value, "fspdate");
            return (Criteria) this;
        }

        public Criteria andFspdateNotEqualTo(Date value) {
            addCriterion("fSPDate <>", value, "fspdate");
            return (Criteria) this;
        }

        public Criteria andFspdateGreaterThan(Date value) {
            addCriterion("fSPDate >", value, "fspdate");
            return (Criteria) this;
        }

        public Criteria andFspdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fSPDate >=", value, "fspdate");
            return (Criteria) this;
        }

        public Criteria andFspdateLessThan(Date value) {
            addCriterion("fSPDate <", value, "fspdate");
            return (Criteria) this;
        }

        public Criteria andFspdateLessThanOrEqualTo(Date value) {
            addCriterion("fSPDate <=", value, "fspdate");
            return (Criteria) this;
        }

        public Criteria andFspdateIn(List<Date> values) {
            addCriterion("fSPDate in", values, "fspdate");
            return (Criteria) this;
        }

        public Criteria andFspdateNotIn(List<Date> values) {
            addCriterion("fSPDate not in", values, "fspdate");
            return (Criteria) this;
        }

        public Criteria andFspdateBetween(Date value1, Date value2) {
            addCriterion("fSPDate between", value1, value2, "fspdate");
            return (Criteria) this;
        }

        public Criteria andFspdateNotBetween(Date value1, Date value2) {
            addCriterion("fSPDate not between", value1, value2, "fspdate");
            return (Criteria) this;
        }

        public Criteria andFglsIsNull() {
            addCriterion("fGLS is null");
            return (Criteria) this;
        }

        public Criteria andFglsIsNotNull() {
            addCriterion("fGLS is not null");
            return (Criteria) this;
        }

        public Criteria andFglsEqualTo(BigDecimal value) {
            addCriterion("fGLS =", value, "fgls");
            return (Criteria) this;
        }

        public Criteria andFglsNotEqualTo(BigDecimal value) {
            addCriterion("fGLS <>", value, "fgls");
            return (Criteria) this;
        }

        public Criteria andFglsGreaterThan(BigDecimal value) {
            addCriterion("fGLS >", value, "fgls");
            return (Criteria) this;
        }

        public Criteria andFglsGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fGLS >=", value, "fgls");
            return (Criteria) this;
        }

        public Criteria andFglsLessThan(BigDecimal value) {
            addCriterion("fGLS <", value, "fgls");
            return (Criteria) this;
        }

        public Criteria andFglsLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fGLS <=", value, "fgls");
            return (Criteria) this;
        }

        public Criteria andFglsIn(List<BigDecimal> values) {
            addCriterion("fGLS in", values, "fgls");
            return (Criteria) this;
        }

        public Criteria andFglsNotIn(List<BigDecimal> values) {
            addCriterion("fGLS not in", values, "fgls");
            return (Criteria) this;
        }

        public Criteria andFglsBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fGLS between", value1, value2, "fgls");
            return (Criteria) this;
        }

        public Criteria andFglsNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fGLS not between", value1, value2, "fgls");
            return (Criteria) this;
        }

        public Criteria andFspareaidIsNull() {
            addCriterion("fSPAreaID is null");
            return (Criteria) this;
        }

        public Criteria andFspareaidIsNotNull() {
            addCriterion("fSPAreaID is not null");
            return (Criteria) this;
        }

        public Criteria andFspareaidEqualTo(Integer value) {
            addCriterion("fSPAreaID =", value, "fspareaid");
            return (Criteria) this;
        }

        public Criteria andFspareaidNotEqualTo(Integer value) {
            addCriterion("fSPAreaID <>", value, "fspareaid");
            return (Criteria) this;
        }

        public Criteria andFspareaidGreaterThan(Integer value) {
            addCriterion("fSPAreaID >", value, "fspareaid");
            return (Criteria) this;
        }

        public Criteria andFspareaidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fSPAreaID >=", value, "fspareaid");
            return (Criteria) this;
        }

        public Criteria andFspareaidLessThan(Integer value) {
            addCriterion("fSPAreaID <", value, "fspareaid");
            return (Criteria) this;
        }

        public Criteria andFspareaidLessThanOrEqualTo(Integer value) {
            addCriterion("fSPAreaID <=", value, "fspareaid");
            return (Criteria) this;
        }

        public Criteria andFspareaidIn(List<Integer> values) {
            addCriterion("fSPAreaID in", values, "fspareaid");
            return (Criteria) this;
        }

        public Criteria andFspareaidNotIn(List<Integer> values) {
            addCriterion("fSPAreaID not in", values, "fspareaid");
            return (Criteria) this;
        }

        public Criteria andFspareaidBetween(Integer value1, Integer value2) {
            addCriterion("fSPAreaID between", value1, value2, "fspareaid");
            return (Criteria) this;
        }

        public Criteria andFspareaidNotBetween(Integer value1, Integer value2) {
            addCriterion("fSPAreaID not between", value1, value2, "fspareaid");
            return (Criteria) this;
        }

        public Criteria andFccdateIsNull() {
            addCriterion("fCCDate is null");
            return (Criteria) this;
        }

        public Criteria andFccdateIsNotNull() {
            addCriterion("fCCDate is not null");
            return (Criteria) this;
        }

        public Criteria andFccdateEqualTo(Date value) {
            addCriterion("fCCDate =", value, "fccdate");
            return (Criteria) this;
        }

        public Criteria andFccdateNotEqualTo(Date value) {
            addCriterion("fCCDate <>", value, "fccdate");
            return (Criteria) this;
        }

        public Criteria andFccdateGreaterThan(Date value) {
            addCriterion("fCCDate >", value, "fccdate");
            return (Criteria) this;
        }

        public Criteria andFccdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fCCDate >=", value, "fccdate");
            return (Criteria) this;
        }

        public Criteria andFccdateLessThan(Date value) {
            addCriterion("fCCDate <", value, "fccdate");
            return (Criteria) this;
        }

        public Criteria andFccdateLessThanOrEqualTo(Date value) {
            addCriterion("fCCDate <=", value, "fccdate");
            return (Criteria) this;
        }

        public Criteria andFccdateIn(List<Date> values) {
            addCriterion("fCCDate in", values, "fccdate");
            return (Criteria) this;
        }

        public Criteria andFccdateNotIn(List<Date> values) {
            addCriterion("fCCDate not in", values, "fccdate");
            return (Criteria) this;
        }

        public Criteria andFccdateBetween(Date value1, Date value2) {
            addCriterion("fCCDate between", value1, value2, "fccdate");
            return (Criteria) this;
        }

        public Criteria andFccdateNotBetween(Date value1, Date value2) {
            addCriterion("fCCDate not between", value1, value2, "fccdate");
            return (Criteria) this;
        }

        public Criteria andFageIsNull() {
            addCriterion("fAge is null");
            return (Criteria) this;
        }

        public Criteria andFageIsNotNull() {
            addCriterion("fAge is not null");
            return (Criteria) this;
        }

        public Criteria andFageEqualTo(Integer value) {
            addCriterion("fAge =", value, "fage");
            return (Criteria) this;
        }

        public Criteria andFageNotEqualTo(Integer value) {
            addCriterion("fAge <>", value, "fage");
            return (Criteria) this;
        }

        public Criteria andFageGreaterThan(Integer value) {
            addCriterion("fAge >", value, "fage");
            return (Criteria) this;
        }

        public Criteria andFageGreaterThanOrEqualTo(Integer value) {
            addCriterion("fAge >=", value, "fage");
            return (Criteria) this;
        }

        public Criteria andFageLessThan(Integer value) {
            addCriterion("fAge <", value, "fage");
            return (Criteria) this;
        }

        public Criteria andFageLessThanOrEqualTo(Integer value) {
            addCriterion("fAge <=", value, "fage");
            return (Criteria) this;
        }

        public Criteria andFageIn(List<Integer> values) {
            addCriterion("fAge in", values, "fage");
            return (Criteria) this;
        }

        public Criteria andFageNotIn(List<Integer> values) {
            addCriterion("fAge not in", values, "fage");
            return (Criteria) this;
        }

        public Criteria andFageBetween(Integer value1, Integer value2) {
            addCriterion("fAge between", value1, value2, "fage");
            return (Criteria) this;
        }

        public Criteria andFageNotBetween(Integer value1, Integer value2) {
            addCriterion("fAge not between", value1, value2, "fage");
            return (Criteria) this;
        }

        public Criteria andFzdtotalsIsNull() {
            addCriterion("fZDTotalS is null");
            return (Criteria) this;
        }

        public Criteria andFzdtotalsIsNotNull() {
            addCriterion("fZDTotalS is not null");
            return (Criteria) this;
        }

        public Criteria andFzdtotalsEqualTo(BigDecimal value) {
            addCriterion("fZDTotalS =", value, "fzdtotals");
            return (Criteria) this;
        }

        public Criteria andFzdtotalsNotEqualTo(BigDecimal value) {
            addCriterion("fZDTotalS <>", value, "fzdtotals");
            return (Criteria) this;
        }

        public Criteria andFzdtotalsGreaterThan(BigDecimal value) {
            addCriterion("fZDTotalS >", value, "fzdtotals");
            return (Criteria) this;
        }

        public Criteria andFzdtotalsGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fZDTotalS >=", value, "fzdtotals");
            return (Criteria) this;
        }

        public Criteria andFzdtotalsLessThan(BigDecimal value) {
            addCriterion("fZDTotalS <", value, "fzdtotals");
            return (Criteria) this;
        }

        public Criteria andFzdtotalsLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fZDTotalS <=", value, "fzdtotals");
            return (Criteria) this;
        }

        public Criteria andFzdtotalsIn(List<BigDecimal> values) {
            addCriterion("fZDTotalS in", values, "fzdtotals");
            return (Criteria) this;
        }

        public Criteria andFzdtotalsNotIn(List<BigDecimal> values) {
            addCriterion("fZDTotalS not in", values, "fzdtotals");
            return (Criteria) this;
        }

        public Criteria andFzdtotalsBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fZDTotalS between", value1, value2, "fzdtotals");
            return (Criteria) this;
        }

        public Criteria andFzdtotalsNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fZDTotalS not between", value1, value2, "fzdtotals");
            return (Criteria) this;
        }

        public Criteria andFpgtotalsIsNull() {
            addCriterion("fPGTotalS is null");
            return (Criteria) this;
        }

        public Criteria andFpgtotalsIsNotNull() {
            addCriterion("fPGTotalS is not null");
            return (Criteria) this;
        }

        public Criteria andFpgtotalsEqualTo(BigDecimal value) {
            addCriterion("fPGTotalS =", value, "fpgtotals");
            return (Criteria) this;
        }

        public Criteria andFpgtotalsNotEqualTo(BigDecimal value) {
            addCriterion("fPGTotalS <>", value, "fpgtotals");
            return (Criteria) this;
        }

        public Criteria andFpgtotalsGreaterThan(BigDecimal value) {
            addCriterion("fPGTotalS >", value, "fpgtotals");
            return (Criteria) this;
        }

        public Criteria andFpgtotalsGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fPGTotalS >=", value, "fpgtotals");
            return (Criteria) this;
        }

        public Criteria andFpgtotalsLessThan(BigDecimal value) {
            addCriterion("fPGTotalS <", value, "fpgtotals");
            return (Criteria) this;
        }

        public Criteria andFpgtotalsLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fPGTotalS <=", value, "fpgtotals");
            return (Criteria) this;
        }

        public Criteria andFpgtotalsIn(List<BigDecimal> values) {
            addCriterion("fPGTotalS in", values, "fpgtotals");
            return (Criteria) this;
        }

        public Criteria andFpgtotalsNotIn(List<BigDecimal> values) {
            addCriterion("fPGTotalS not in", values, "fpgtotals");
            return (Criteria) this;
        }

        public Criteria andFpgtotalsBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fPGTotalS between", value1, value2, "fpgtotals");
            return (Criteria) this;
        }

        public Criteria andFpgtotalsNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fPGTotalS not between", value1, value2, "fpgtotals");
            return (Criteria) this;
        }

        public Criteria andFchr1IsNull() {
            addCriterion("fChr1 is null");
            return (Criteria) this;
        }

        public Criteria andFchr1IsNotNull() {
            addCriterion("fChr1 is not null");
            return (Criteria) this;
        }

        public Criteria andFchr1EqualTo(String value) {
            addCriterion("fChr1 =", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1NotEqualTo(String value) {
            addCriterion("fChr1 <>", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1GreaterThan(String value) {
            addCriterion("fChr1 >", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1GreaterThanOrEqualTo(String value) {
            addCriterion("fChr1 >=", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1LessThan(String value) {
            addCriterion("fChr1 <", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1LessThanOrEqualTo(String value) {
            addCriterion("fChr1 <=", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1Like(String value) {
            addCriterion("fChr1 like", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1NotLike(String value) {
            addCriterion("fChr1 not like", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1In(List<String> values) {
            addCriterion("fChr1 in", values, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1NotIn(List<String> values) {
            addCriterion("fChr1 not in", values, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1Between(String value1, String value2) {
            addCriterion("fChr1 between", value1, value2, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1NotBetween(String value1, String value2) {
            addCriterion("fChr1 not between", value1, value2, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFyearIsNull() {
            addCriterion("fYear is null");
            return (Criteria) this;
        }

        public Criteria andFyearIsNotNull() {
            addCriterion("fYear is not null");
            return (Criteria) this;
        }

        public Criteria andFyearEqualTo(String value) {
            addCriterion("fYear =", value, "fyear");
            return (Criteria) this;
        }

        public Criteria andFyearNotEqualTo(String value) {
            addCriterion("fYear <>", value, "fyear");
            return (Criteria) this;
        }

        public Criteria andFyearGreaterThan(String value) {
            addCriterion("fYear >", value, "fyear");
            return (Criteria) this;
        }

        public Criteria andFyearGreaterThanOrEqualTo(String value) {
            addCriterion("fYear >=", value, "fyear");
            return (Criteria) this;
        }

        public Criteria andFyearLessThan(String value) {
            addCriterion("fYear <", value, "fyear");
            return (Criteria) this;
        }

        public Criteria andFyearLessThanOrEqualTo(String value) {
            addCriterion("fYear <=", value, "fyear");
            return (Criteria) this;
        }

        public Criteria andFyearLike(String value) {
            addCriterion("fYear like", value, "fyear");
            return (Criteria) this;
        }

        public Criteria andFyearNotLike(String value) {
            addCriterion("fYear not like", value, "fyear");
            return (Criteria) this;
        }

        public Criteria andFyearIn(List<String> values) {
            addCriterion("fYear in", values, "fyear");
            return (Criteria) this;
        }

        public Criteria andFyearNotIn(List<String> values) {
            addCriterion("fYear not in", values, "fyear");
            return (Criteria) this;
        }

        public Criteria andFyearBetween(String value1, String value2) {
            addCriterion("fYear between", value1, value2, "fyear");
            return (Criteria) this;
        }

        public Criteria andFyearNotBetween(String value1, String value2) {
            addCriterion("fYear not between", value1, value2, "fyear");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNameIsNull() {
            addCriterion("fCompanyID_Name is null");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNameIsNotNull() {
            addCriterion("fCompanyID_Name is not null");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNameEqualTo(String value) {
            addCriterion("fCompanyID_Name =", value, "fcompanyidName");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNameNotEqualTo(String value) {
            addCriterion("fCompanyID_Name <>", value, "fcompanyidName");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNameGreaterThan(String value) {
            addCriterion("fCompanyID_Name >", value, "fcompanyidName");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNameGreaterThanOrEqualTo(String value) {
            addCriterion("fCompanyID_Name >=", value, "fcompanyidName");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNameLessThan(String value) {
            addCriterion("fCompanyID_Name <", value, "fcompanyidName");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNameLessThanOrEqualTo(String value) {
            addCriterion("fCompanyID_Name <=", value, "fcompanyidName");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNameLike(String value) {
            addCriterion("fCompanyID_Name like", value, "fcompanyidName");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNameNotLike(String value) {
            addCriterion("fCompanyID_Name not like", value, "fcompanyidName");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNameIn(List<String> values) {
            addCriterion("fCompanyID_Name in", values, "fcompanyidName");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNameNotIn(List<String> values) {
            addCriterion("fCompanyID_Name not in", values, "fcompanyidName");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNameBetween(String value1, String value2) {
            addCriterion("fCompanyID_Name between", value1, value2, "fcompanyidName");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNameNotBetween(String value1, String value2) {
            addCriterion("fCompanyID_Name not between", value1, value2, "fcompanyidName");
            return (Criteria) this;
        }

        public Criteria andFtypeidNameIsNull() {
            addCriterion("fTypeID_Name is null");
            return (Criteria) this;
        }

        public Criteria andFtypeidNameIsNotNull() {
            addCriterion("fTypeID_Name is not null");
            return (Criteria) this;
        }

        public Criteria andFtypeidNameEqualTo(String value) {
            addCriterion("fTypeID_Name =", value, "ftypeidName");
            return (Criteria) this;
        }

        public Criteria andFtypeidNameNotEqualTo(String value) {
            addCriterion("fTypeID_Name <>", value, "ftypeidName");
            return (Criteria) this;
        }

        public Criteria andFtypeidNameGreaterThan(String value) {
            addCriterion("fTypeID_Name >", value, "ftypeidName");
            return (Criteria) this;
        }

        public Criteria andFtypeidNameGreaterThanOrEqualTo(String value) {
            addCriterion("fTypeID_Name >=", value, "ftypeidName");
            return (Criteria) this;
        }

        public Criteria andFtypeidNameLessThan(String value) {
            addCriterion("fTypeID_Name <", value, "ftypeidName");
            return (Criteria) this;
        }

        public Criteria andFtypeidNameLessThanOrEqualTo(String value) {
            addCriterion("fTypeID_Name <=", value, "ftypeidName");
            return (Criteria) this;
        }

        public Criteria andFtypeidNameLike(String value) {
            addCriterion("fTypeID_Name like", value, "ftypeidName");
            return (Criteria) this;
        }

        public Criteria andFtypeidNameNotLike(String value) {
            addCriterion("fTypeID_Name not like", value, "ftypeidName");
            return (Criteria) this;
        }

        public Criteria andFtypeidNameIn(List<String> values) {
            addCriterion("fTypeID_Name in", values, "ftypeidName");
            return (Criteria) this;
        }

        public Criteria andFtypeidNameNotIn(List<String> values) {
            addCriterion("fTypeID_Name not in", values, "ftypeidName");
            return (Criteria) this;
        }

        public Criteria andFtypeidNameBetween(String value1, String value2) {
            addCriterion("fTypeID_Name between", value1, value2, "ftypeidName");
            return (Criteria) this;
        }

        public Criteria andFtypeidNameNotBetween(String value1, String value2) {
            addCriterion("fTypeID_Name not between", value1, value2, "ftypeidName");
            return (Criteria) this;
        }

        public Criteria andFmkindidNameIsNull() {
            addCriterion("fMKindID_Name is null");
            return (Criteria) this;
        }

        public Criteria andFmkindidNameIsNotNull() {
            addCriterion("fMKindID_Name is not null");
            return (Criteria) this;
        }

        public Criteria andFmkindidNameEqualTo(String value) {
            addCriterion("fMKindID_Name =", value, "fmkindidName");
            return (Criteria) this;
        }

        public Criteria andFmkindidNameNotEqualTo(String value) {
            addCriterion("fMKindID_Name <>", value, "fmkindidName");
            return (Criteria) this;
        }

        public Criteria andFmkindidNameGreaterThan(String value) {
            addCriterion("fMKindID_Name >", value, "fmkindidName");
            return (Criteria) this;
        }

        public Criteria andFmkindidNameGreaterThanOrEqualTo(String value) {
            addCriterion("fMKindID_Name >=", value, "fmkindidName");
            return (Criteria) this;
        }

        public Criteria andFmkindidNameLessThan(String value) {
            addCriterion("fMKindID_Name <", value, "fmkindidName");
            return (Criteria) this;
        }

        public Criteria andFmkindidNameLessThanOrEqualTo(String value) {
            addCriterion("fMKindID_Name <=", value, "fmkindidName");
            return (Criteria) this;
        }

        public Criteria andFmkindidNameLike(String value) {
            addCriterion("fMKindID_Name like", value, "fmkindidName");
            return (Criteria) this;
        }

        public Criteria andFmkindidNameNotLike(String value) {
            addCriterion("fMKindID_Name not like", value, "fmkindidName");
            return (Criteria) this;
        }

        public Criteria andFmkindidNameIn(List<String> values) {
            addCriterion("fMKindID_Name in", values, "fmkindidName");
            return (Criteria) this;
        }

        public Criteria andFmkindidNameNotIn(List<String> values) {
            addCriterion("fMKindID_Name not in", values, "fmkindidName");
            return (Criteria) this;
        }

        public Criteria andFmkindidNameBetween(String value1, String value2) {
            addCriterion("fMKindID_Name between", value1, value2, "fmkindidName");
            return (Criteria) this;
        }

        public Criteria andFmkindidNameNotBetween(String value1, String value2) {
            addCriterion("fMKindID_Name not between", value1, value2, "fmkindidName");
            return (Criteria) this;
        }

        public Criteria andFlevelEqualTo(int value) {
            addCriterion("fLevel =", value, "flevel");
            return (Criteria) this;
        }

        public Criteria andFlevelNotEqualTo(int value) {
            addCriterion("fLevel <>", value, "flevel");
            return (Criteria) this;
        }

        public Criteria andFlevelGreaterThan(int value) {
            addCriterion("fLevel >", value, "flevel");
            return (Criteria) this;
        }

        public Criteria andFlevelGreaterThanOrEqualTo(int value) {
            addCriterion("fLevel >=", value, "flevel");
            return (Criteria) this;
        }

        public Criteria andFlevelLessThan(int value) {
            addCriterion("fLevel <", value, "flevel");
            return (Criteria) this;
        }

        public Criteria andFlevelLessThanOrEqualTo(int value) {
            addCriterion("fLevel <=", value, "flevel");
            return (Criteria) this;
        }

        public Criteria andFlevelBetween(int value1, int value2) {
            addCriterion("fLevel between", value1, value2, "flevel");
            return (Criteria) this;
        }

        public Criteria andFlevelNotBetween(int value1, int value2) {
            addCriterion("fLevel not between", value1, value2, "flevel");
            return (Criteria) this;
        }

        public Criteria andFdetailEqualTo(int value) {
            addCriterion("fDetail =", value, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFdetailNotEqualTo(int value) {
            addCriterion("fDetail <>", value, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFdetailGreaterThan(int value) {
            addCriterion("fDetail >", value, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFdetailGreaterThanOrEqualTo(int value) {
            addCriterion("fDetail >=", value, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFdetailLessThan(int value) {
            addCriterion("fDetail <", value, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFdetailLessThanOrEqualTo(int value) {
            addCriterion("fDetail <=", value, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFdetailBetween(int value1, int value2) {
            addCriterion("fDetail between", value1, value2, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFdetailNotBetween(int value1, int value2) {
            addCriterion("fDetail not between", value1, value2, "fdetail");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}